running sql scripts

[battaman]

Is there any way to run a SQL script from the command line without using SQLPlus? With SQLPlus I could use:

sqlplus ctxsys/ctxsys @sqlscript.sql

I would like to be able to do this without using SQLPlus

Thanks,

Battaman

 

[carp]

Nope. You need a utility that understands Oracle and SQL, and from the command line you're pretty much stuck with SQLPlus or Server Manager.

 

[faheemrao]

Yes,you can run the sql scripts without using SQLPlus ,
you can use server Manager to run those scripts.

try this


c:\oracle\ora81\bin\svrmgrl @SQLScripts.sql


but change the path what ever is on your system.