| log miner [message #586993] |
Wed, 12 June 2013 06:12  |
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
|
Member |
|
|
hi,
I am using log miner to check wrong update statement executed, when i execute the query to read data from log files the result shown in the format which is difficult to understand , how can i use log miner to retrieve data in human readable format.
[code]
select scn, sql_redo from v$logmnr_contents;
update "UNKNOWN"."OBJ# 12320" set "COL 28" = HEXTORAW('00'), "COL 70" = NULL where "COL 1" = HEXTORAW('414c4552545f515545')
[code]
|
|
|
|
|
|
|
|
|
|
|
|
| Re: log miner [message #587067 is a reply to message #587062] |
Wed, 12 June 2013 08:56  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:As i use drop table dept purge , and can't see any information in logmnr_contents view.
I don't know, never tried to search such statement.
If you drop with "purge" then you have a delete on sys.obj$ otherwise you have an update on this table.
This is the only clue I can give you if Log Miner does not give the complete DROP statement.
Regards
Michel
[Updated on: Wed, 12 June 2013 08:58] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
