| Loosing Database Trigger [message #57140] |
Thu, 22 May 2003 06:44  |
Girish Kumar
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
Hi ,
We are facing some serious problems, we run Oracle 8i in a sun solaris box, where there are some scripts that run at specific time. the scripts normally drops all the application users (users means not the production database) after running the script we are loosing so many triggers randomly every day. scripts run on Solaris box. have any one come thru such problems and fixed , if so pls let me know the cause and action.
R.
Girish
|
|
|
|
| Re: Loosing Database Trigger [message #57141 is a reply to message #57140] |
Thu, 22 May 2003 07:03  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you u drop the users , the triggers created by / owned by users are also dropped.
Please make sure, the application users do not own the triggers that are used by the production schema (user)
and
NO trigger owned by the production schema has the base table owned by the application users.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
