sys.dbms_logmnr.add_logfile : dbms_logmnr « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_logmnr
SQL>
SQL> begin
  2     sys.dbms_logmnr.add_logfile( 'C:\ARC00028.001',sys.dbms_logmnr.NEW );
  3  end;
  4  /
begin
*
ERROR at line 1:
ORA-01284: file C:\ARC00028.001 cannot be opened
ORA-00308: cannot open archived log 'C:\ARC00028.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 2


SQL>








31.14.dbms_logmnr
31.14.1.sys.dbms_logmnr.start_logmnr
31.14.2.sys.dbms_logmnr.add_logfile
31.14.3.sys.dbms_logmnr_d.build
31.14.4.dbms_logmnr.add_logfile