| Re: urgent...how do i know which user has dropped a table from the database [message #49812] |
Mon, 11 February 2002 08:36 |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
Rajesh,
I do not think that you have any chance but
something to investigate :-
a. O/S logs - who was logged in
Are they all proper users
and all allowed in at that time, and were
they really logged in.
b. Later (8i +) versions of Oracle allow
some recovery through the archive log files.
If you are at 8i or later, visit MetaLink and
search for details about using archive log files
for recovery. It might just give you something
to start with.
c. An obviously - turn on auditing for DDL - at
least - using a trigger.
I hope some of this helps
pwl
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
