Question: I am trying to run two
SQL files in a DOS Windows script, but it hangs:
sqlplus "/as sysdba" @C:\Users\Test\1.sql
How do I execute two SQL files from Windows?
Answer: You can execute many sql
scripts and commands in Windows sql*plus by using this
technique, using the "type" command to paste together all of
type C:\Users\Test\1.sql >
type C:\Users\Test\2.sql >>
sqlplus "/as sysdba" @C:\temp\runme.sql
Also see Oracle scripts
Windows for the Oracle DBA
The landmark book
Windows for the Oracle DBA is a comprehensive overview of
everything an Oracle DBA needs to know to manage Oracle on
Windows. Order directly from Rampant and save 30%.
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise.
technology is changing and we strive to update our BC Oracle support
information. If you find an error or have a suggestion for
improving our content, we would appreciate your feedback. Please
and include the URL for the page.
Copyright © 1996 - 2023
All rights reserved by
is the registered trademark of Oracle Corporation.