Re: SVRMGR - executing scripts

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Thu, 12 Aug 1999 12:53:51 +0100
Message-ID: <7ouckk$jd0$1@taliesin.netcom.net.uk>

John Edwards wrote in message <7oubtf$2r6s$1_at_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"

Leave out "command="

Alex Received on Thu Aug 12 1999 - 06:53:51 CDT