John Clarke wrote:
If you're on 9iR2+, Check out Metalink doc 291686.1. Specifically, section 10-2.
That was very helpful.
I got what I needed with this:
EXECUTE DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => '/path/0000012454.arc',OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
SELECT SCN, TO_CHAR (TIMESTAMP, 'DD-MON-YYYY HH24:MI:SS') TIMESTAMP, seg_owner, sql_redo FROM v$logmnr_contents WHERE seg_owner LIKE '%' AND sql_redo LIKE '%' ORDER BY SCN;
EXECUTE DBMS_LOGMNR.end_LOGMNR;
thanks to everyone for their help.
-- //www.freelists.org/webpage/oracle-l