Home » RDBMS Server » Server Administration » Info about droped objects
icon8.gif  Info about droped objects [message #257168] Tue, 07 August 2007 12:37 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Hello Forum

Is there anyway I can know when my tables were droped. Actually somebody droped tables from my databases & I want to know when it was droped & by whom?

Thanks a lot in advance

[Updated on: Tue, 07 August 2007 12:47]

Report message to a moderator

Re: Info about droped objects [message #257172 is a reply to message #257168] Tue, 07 August 2007 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: Info about droped objects [message #257175 is a reply to message #257172] Tue, 07 August 2007 12:48 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
I am using oracle 9.2.0.7. on solaris 5.9.

Report message to a moderator

Re: Info about droped objects [message #257177 is a reply to message #257175] Tue, 07 August 2007 12:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Afterwards, your only solution is Log Miner.
Now you can enable audit for future drops.

Regards
Michel

Report message to a moderator

Re: Info about droped objects [message #257188 is a reply to message #257177] Tue, 07 August 2007 13:08 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
If possible, Can you please guide me how to execute this log miner to determine the time for droped objects.

It ll really help me a lot.

Thanks a lot

Report message to a moderator

Re: Info about droped objects [message #257190 is a reply to message #257188] Tue, 07 August 2007 13:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Logminer

http://www.scribd.com/doc/173842/Oracle-Log-Miner

Report message to a moderator

Re: Info about droped objects [message #257199 is a reply to message #257188] Tue, 07 August 2007 13:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle9i Database Administrator's Guide
Chapter 9 Using LogMiner to Analyze Redo Logs
Especially sections Steps in a Typical LogMiner Session and Example Uses of LogMiner

Regards
Michel

[Updated on: Tue, 07 August 2007 13:36]

Report message to a moderator

Re: Info about droped objects [message #257229 is a reply to message #257168] Tue, 07 August 2007 16:50 Go to previous message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
thanks a lot all for help....

[Updated on: Thu, 20 September 2007 14:43] by Moderator

Report message to a moderator

Previous Topic: SQL Tunning Advisor
Next Topic: dbora startup issues
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 14:01:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.