spool file
How can I put OS PID to SQLPLUS SPOOL FILENAME?
I tried $$ it got an :SP2-0332: Cannot create spool file error.
(SQL>spool test$$)
on OS:
odidev2$ echo "test PID" > test$$
odidev2$ ls -l test*
-rw-r--r-- 1 oracle dba 9 18 Dec 2008 test458858
(OS VERSION:AIX 5.3,ORACLE 9.2.0.7)
I tried $$ it got an :SP2-0332: Cannot create spool file error.
(SQL>spool test$$)
on OS:
odidev2$ echo "test PID" > test$$
odidev2$ ls -l test*
-rw-r--r-- 1 oracle dba 9 18 Dec 2008 test458858
(OS VERSION:AIX 5.3,ORACLE 9.2.0.7)
0