Re: SVRMGR - executing scripts

Use this type of command from within server manager:

SVRMGR> @test.sql

If you want to run a command file from the OS command line use:

svrmgrl command=@/opt/apps/ora/rdbms/admin/catproc

Hope this helps.

Kenny Gump

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"
>
>
Received on Thu Aug 12 1999 - 06:55:31 CDT