Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SVRMGR - executing scripts
Hi,
Can anyone tell me how to execute an SQL script from the server manager tool (in "Line Mode")?
The Server Manager's User Guide says:
"Running Scripts
In line mode you can also run scripts using the @ command. For example, to run the script TEST.SQL, issue the statement @test. If you do not specify a script name, Server Manager prompts you for one, as in the following example:
SVRMGR> @ Name of script file: test"
I've tried this and many other combinations but all I get is this:
"SVRMGR> command=@/opt/apps/ora/rdbms/admin/catproc;
/opt/apps/ora/rdbms/admin/catproc
*
ORA-00900: invalid SQL statement"
Received on Thu Aug 12 1999 - 06:39:56 CDT