SYSDATE - 1 error on pl/sql function

Posted by ayo on Stack Overflow See other posts from Stack Overflow or by ayo
Published on 2009-04-23T15:56:26Z Indexed on 2010/04/08 23:03 UTC
Read the original article Hit count: 310

Filed under:
|

Hi curtisk/all,

I have an issue:

when i issue this function below ti gives me the following error:

select 'EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'''||name||'''||,OPTIONS=>DBMS_LOGMNR.NEW);'
 from v\$archived_log 
where name is not null;

select 'EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME =>'''||name||'''||,OPTIONS=>DBMS_LOGMNR.ADDFILE);' 
 from v\$archived_log 
where name is not null;


EXECUTE DBMS_LOGMNR.START_LOGMNR( STARTTIME => SYSDATE - 1, ENDTIME => SYSDATE,
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.CONTINUOUS_MINE +
DBMS_LOGMNR.COMMITTED_DATA_ONLY + DBMS_LOGMNR.PRINT_PRETTY_SQL);

Error:

*
ERROR at line 1:
ORA-01291: missing logfile
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 1

But i have added all the archived logs for several days before and my sysdate is at today.

Kindly help out on this issue.

thanks.

Reagrds

Ayo

© Stack Overflow or respective owner

Related posts about plsql

Related posts about Oracle