Re: SVRMGR - executing scripts

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Thu, 12 Aug 1999 13:42:08 GMT
Message-ID: <7ouive$3oq$1@nnrp1.deja.com>

Have you looked into the content of "/opt/apps/ora/rdbms/admin/catproc"?

James

In article <7oubtf$2r6s$1_at_quince.news.easynet.net>, "John Edwards" <john_at_zinc.co.uk> wrote:
> 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"
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 08:42:08 CDT