melalui SQL> sudah saya coba saran anda dibawah ini, namun masih
saja keluar error yg sama ORA-01306 dbms_logmnr.start_logmnr()must be
invoked before selecting from v_$logmnr_contents.
terima kasih
siswanto
>
> sepertinya urut2urutan miningnya saja kurang.....
> coba steps berikut.... (tested on 9i/10g)
>
>
> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
>
> EXECUTE DBMS_LOGMNR_D.SET_TABLESPACE('USERS');
>
> select name from v$archived_log order by recid;
>
> exec
> DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME=>'C:\DOCS\111-
TMPARC00072_0609695236.001');
>
> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS =>
> DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
>
> select * from V$LOGMNR_CONTENTS;
>
> regards
> ujang
>
