Re: Need another set of eyes

> SQL> declare
> 2 l_name v$archived_log.name%type;
> 3 begin
> 4 select name into l_name
> 5 from v$archived_log
> 6 where completion_time = ( select max(completion_time)
> 7 from v$archived_log);
> 8 sys.dbms_logmnr.add_logfile(l_name, sys.dbms_logmnr.NEW);
> 9 end;
> 10 /
> declare
> *

Hi Ed,

I ran your script on my 9i database. No problem, works as designed. Can't imagine where the 'sql' string comes from. What version /OS are you on?

Stephan Received on Wed Aug 06 2003 - 08:14:44 CDT