Re: Need another set of eyes

On Wed, 06 Aug 2003 15:14:44 +0200, Stephan Bressler <agadir_at_web.de> wrote:

>
>> 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

Win2K Server Received on Wed Aug 06 2003 - 08:58:58 CDT