Database Administration (MOSC)

MOSC Banner

logminer issues

edited Jan 10, 2013 1:11PM in Database Administration (MOSC) 8 commentsAnswered
i tried to recover a table using logminer as follows :

SQL>begin
dbms_logmnr.start_logmnr (
starttime => '9-jan-2013 11:00:00',
endtime => '9-jan-2013 11:00:00,
options => dbms_logmnr.dict_from_online_catalog +
dbms_logmnr.continuous_mine +
dbms_logmnr.no_sql_delimiter +
dbms_logmnr.print_pretty_sql
);
end;
/

but when i selected from v$logmnr_contents its giving me "UNKNOWN" username and os_username.

any ideas why ?


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center