|
-
If you generally run these sql scripts form one machine, you could alter your registry for SQLPATH:
HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\(your oracle home)
open the SQLPATH and enter the folder locations, separated by a semicolon:
example - "c:\new_directry1;c:\new_directry2;c:\new_directry3;c:\new_directry4"
after updating your SQLPATH key, you will be able to type "@(name of sql script).sql" from sqlplus prompt and it will iterate through the directories in the registry path and run the first script it finds with that name.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|