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> declare
  2      l_name v$archived_log.name%type;
  3  begin
  4      select name into l_name from v$archived_log
  5       where completion_time = ( select max(completion_time) from v$archived_log );
  6
  7      sys.dbms_logmnr.add_logfile( l_name, sys.dbms_logmnr.NEW );
  8  end;
  9  /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 4