Home » RDBMS Server » Server Administration » deleted record
deleted record [message #227141] Tue, 27 March 2007 07:35 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
i want to know who had deleted the record from master table eg:master_data table
has this record is very important and refered by all other table
its very urgent
thanxs
Re: deleted record [message #227145 is a reply to message #227141] Tue, 27 March 2007 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at LogMiner.

Regards
Michel
Re: deleted record [message #227148 is a reply to message #227141] Tue, 27 March 2007 07:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Another option is auditing if auditing enable.


regards
Taj
Re: deleted record [message #227150 is a reply to message #227141] Tue, 27 March 2007 07:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Depending on your retention time, you can also consider FLASHBACK QUERY.
Re: deleted record [message #227179 is a reply to message #227141] Tue, 27 March 2007 08:23 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Would you PLEASE use punctuation? I have no idea where one sentence starts and one ends. it makes the question sound like it comes from an illiterate.
Re: deleted record [message #227201 is a reply to message #227179] Tue, 27 March 2007 09:11 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Too urgent problem for punctuation. Razz

Michel
Previous Topic: Value of parameter from V$parameter
Next Topic: EXP-00056
Goto Forum:
  


Current Time: Fri Dec 09 15:19:26 CST 2016

Total time taken to generate the page: 0.05834 seconds