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

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.