Wednesday, March 07, 2012

special characters in sql*plus

the following characters are replaces by:
@ => ORACLE_SID
? => ORACLE_HOME

SQL> spool test_@.log
SQL> prompt hi
hi
SQL> spool off
SQL> !ls -rlt test*
-rw-r--r-- 1 oravcms oravcms 136 Mar 7 14:32 test_VCMST.log

Oracle Expert » How to spot duplicate datafiles

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.