 Logminer [message #264277] |
Sun, 02 September 2007 14:10  |
dbasudar
Messages: 8
Registered: August 2007
Location: chennai
|
Junior Member |
|
|
hi,
i accidentally dropped a table from my database.when i tried it to restore it,i had an idea of using logminer.bcoz i doesnot know the exact time,when i drooped it.i used the normal procedures...but when i tried to do
SELECT scn,timestamp,sql_redo FROM v$logmnr_contents where sql_redo='%DROP%';
no rows have been selected....
but that table doesnot exixts....
can anyone help me regarding this...
thanks in advance...
|
|
|
|
|
|
|
|
| Re: Logminer [message #264311 is a reply to message #264277] |
Mon, 03 September 2007 00:11  |
gagan_7_7
Messages: 1
Registered: September 2006
|
Junior Member |
|
|
Hi,
Please syntax of the query is not correct:
SELECT scn,timestamp,sql_redo FROM v$logmnr_contents where sql_redo like '%DROP%';
Then Try, it would really works
|
|
|
|
|
|
| Re: Logminer [message #264471 is a reply to message #264277] |
Mon, 03 September 2007 08:20 |
dbasudar
Messages: 8
Registered: August 2007
Location: chennai
|
Junior Member |
|
|
i used oracle 9i...
i dont that table in recycle bin...
i checked it out...my syntax is correct...
Hi arju,i cant understand wht do u say...
Thank u once again
|
|
|
|
| Re: Logminer [message #264483 is a reply to message #264471] |
Mon, 03 September 2007 09:00 |
lecorr
Messages: 17
Registered: October 2006
Location: Courbevoie, France
|
Junior Member |
|
|
Hi,
you mean you're looking for a sql_redo which has for value '%DROP%'?
Not for something LIKE '%DROP%' (for example 'DROP TABLE...')?
And maybe you should also look for a '%drop%'?
I'm not a logminer specialist, so maybe your syntax is OK, but I doubt it is.
Regards,
Christian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
