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
On 8/28/07, siswanto <[EMAIL PROTECTED]> wrote:
>
> mohon dibantu.
> saya sedang menggunakan view log miner dg menggunakan PLSQL. dg
> command SQL :
> select l.scn, l.sql_redo, l.sql_undo,l.username from
> v_$logmnr_contents l
>
> namun ada pesan error ORA-01306 dbms_logmnr.start_logmnr()must be
> invoked before selecting from v_$logmnr_contents.
>
> apa maksud error tsb diatas dan apa yg harus saya lakukan agar view
> v_$logmnr_contents dapat dilihat contentsnya.
>
> terima kasih telah membaca dan merespon.
>
> siswanto
>
>
>
--
regards
ujang
[Non-text portions of this message have been removed]
