Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SVRMGR - executing scripts

SVRMGR - executing scripts

From: John Edwards <john_at_zinc.co.uk>
Date: Thu, 12 Aug 1999 12:39:56 +0100
Message-ID: <7oubtf$2r6s$1@quince.news.easynet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US