Home » RDBMS Server » Server Administration » to find parent table (oracle 10g/linuix)
icon5.gif  to find parent table [message #427319] Thu, 22 October 2009 00:35 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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.
Previous Topic: can't increase sga_target parameter (merged 4)
Next Topic: Database open issue
Goto Forum:
  


Current Time: Sat Sep 24 21:29:21 CDT 2016

Total time taken to generate the page: 0.07145 seconds