SQL> conn /as sysdba
Connected.
SQL> show parameter utl
SQL> @?/rdbms/admin/dbmslm.sql
Package created.
Grant succeeded.
SQL> @?/rdbms/admin/dbmslmd.sql
Procedure created.
No errors.
Grant succeeded.
PL/SQL procedure successfully completed.
Package created.
SQL> alter system set utl_file_dir='/oracle/304/arch' scope=spfile;
System altered.
SQL> shutdown immediate
SQL> startup
SQL> execute dbms_logmnr_d.build ('test.ora','/oracle/304/arch');
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.add_logfile (logfilename=>'/oracle/304/arch/inst933/arch_1_507.arc',options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.add_logfile (logfilename=>'/oracle/304/arch/inst933/arch_1_508.arc',options=>dbms_logmnr.addfile);
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.start_logmnr(dictfilename=>'/oracle/304/arch/test.ora');
PL/SQL procedure successfully completed.
SQL> desc v$logmnr_contents
SQL> execute dbms_logmnr.end_logmnr;[@more@]
Connected.
SQL> show parameter utl
SQL> @?/rdbms/admin/dbmslm.sql
Package created.
Grant succeeded.
SQL> @?/rdbms/admin/dbmslmd.sql
Procedure created.
No errors.
Grant succeeded.
PL/SQL procedure successfully completed.
Package created.
SQL> alter system set utl_file_dir='/oracle/304/arch' scope=spfile;
System altered.
SQL> shutdown immediate
SQL> startup
SQL> execute dbms_logmnr_d.build ('test.ora','/oracle/304/arch');
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.add_logfile (logfilename=>'/oracle/304/arch/inst933/arch_1_507.arc',options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.add_logfile (logfilename=>'/oracle/304/arch/inst933/arch_1_508.arc',options=>dbms_logmnr.addfile);
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.start_logmnr(dictfilename=>'/oracle/304/arch/test.ora');
PL/SQL procedure successfully completed.
SQL> desc v$logmnr_contents
SQL> execute dbms_logmnr.end_logmnr;[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10897379/viewspace-964916/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10897379/viewspace-964916/