Saturday, November 10, 2012

How to run oracle sql scripts from command prompt

Thought it seems to.be fundamental, some times on time when it needs things may not be re-collected immediately. For any one's quick reference....

Here we go,

For example :
The DB script which you want to run consider it's name is 'run.sql' and it is in C:\ drive @ Scripts folder.
So go to command prompt ->  and be in the folder where script is available.
It will be like
 
c:\scripts\sqlplus SchemaName/dataSourceName @ run.sql

Hope it helps some one.


Thanks,
Ravi

No comments:

Post a Comment