Tuesday, March 06, 2012

ORA-60019 on installation

OTN Discussion Forums : ORA-60019 on installation ...

 

"ORA-60019: creating initial extent of size 8 in tablespace of extent size 14"

In my case , the tablespace was created with uniform size 8k*8=64k, which is too small.

Given that the block size is 8192, the extent size of the tablespace should be at least  (8192*14) + 1 = 114689.

So after clean out object inside the tablespace by vendor, I re-create the tablespace with system-managed extent size.