-
Hi All,
Is there anyway i can log the errors into a log file when i am executing the script file which creates database, tablespaces, schema, tables, etc...
Also i want to branch or terminate the script when an error occurs. Means, while creating database/tablespace/schema if i get an error i want to terminate the script.
How to do this. Are there any script generating tools that will do this for me.
Thanks in advance
Regards
Jagannadh
Jagannadh
-
In your sqlplus script, put:
WHENEVER SQLERROR EXIT SQL.SQLCODE
Jeff Hunter
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
|