 to find parent table [message #427319] |
Thu, 22 October 2009 00:35  |
m.veerabahu
Messages: 1
Registered: October 2009
Location: india,chennai
|
Junior Member |
|
|
there is a table in our db in which data gets continuously updated (must be due to some trigger on some parent table ). But we don't know the trigger name or the parent table name.
Now i need to find the parent table do to which the child table is getting updates.
or is there is any other possibilities for the data updation other than triggers???
checked DBA_DEPENDENCIES could not find anything????
any tips???????
|
|
|
|
| Re: to find parent table [message #427322 is a reply to message #427319] |
Thu, 22 October 2009 00:49  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:checked DBA_DEPENDENCIES could not find anything????
Did you define constraints!!!!!!!!!!!
Quote:is there is any other possibilities for the data updation other than triggers???
Many!!!!!!!!!!!!!!!!!
Quote:any tips???????
Activate trace!!!!!!!!!!!!!!!!!!!!!
or audit!!!!!!!!!!!!!!!!!!!!!
Regards
Michel
[Updated on: Thu, 22 October 2009 00:50] Report message to a moderator |
|
|
|
| Re: to find parent table [message #427351 is a reply to message #427322] |
Thu, 22 October 2009 03:15 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Or look in DBA_SOURCE for the name of the table that is being updated.
Or try to lock the whole table, and then look at DBA_BLOCKERS, see which session is blocking your lock, and then see what code that session is running.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
