OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » deleted record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

deleted record [message #227141]

Tue, 27 March 2007 07:35

oracle_coorgi
Messages: 188
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

Report message to a moderator

Re: deleted record [message #227145 is a reply to message #227141]

Tue, 27 March 2007 07:46

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at LogMiner.

Regards
Michel

Report message to a moderator

Re: deleted record [message #227148 is a reply to message #227141]

Tue, 27 March 2007 07:50

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Another option is auditing if auditing enable.

regards
Taj

Report message to a moderator

Re: deleted record [message #227150 is a reply to message #227141]

Tue, 27 March 2007 07:51

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Depending on your retention time, you can also consider FLASHBACK QUERY.

Report message to a moderator

Re: deleted record [message #227179 is a reply to message #227141]

Tue, 27 March 2007 08:23

joy_division
Messages: 4963
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.

Report message to a moderator

Re: deleted record [message #227201 is a reply to message #227179]

Tue, 27 March 2007 09:11

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Too urgent problem for punctuation. Razz

Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:37:52 CDT 2024