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