OraFAQ Forum: Server Administration » Options parameter in SYS.DBMS_LOGMNR.START

Home » RDBMS Server » Server Administration » Options parameter in SYS.DBMS_LOGMNR.START_LOGMNR

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Options parameter in SYS.DBMS_LOGMNR.START_LOGMNR [message #62218]

Tue, 06 July 2004 00:15

Sami Zeitoun
Messages: 8
Registered: June 2004

Junior Member

How do I pass more than one flag in the options paramter when I call SYS.DBMS_LOGMNR.START_LOGMNR??
I want to pass the two parameters COMMITTED_DATA_ONLY and DICT_FROM_ONLINE_CATALOG.
When I had one flag I used the following:
�
SQL> begin SYS.DBMS_LOGMNR.START_LOGMNR(
2�startscn => 6024688 ,
3�options =>SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG
4 );
5�end;
6�/
�
How should I do it now??
Thanks.

Report message to a moderator

Re: Options parameter in SYS.DBMS_LOGMNR.START_LOGMNR [message #62231 is a reply to message #62218]

Tue, 06 July 2004 06:29

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You need to add the values together:

SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => -
2 DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + -
3 DBMS_LOGMNR.COMMITTED_DATA_ONLY, -
4 STARTTIME => TO_DATE('06-Jul-2004 08:00:00', 'DD-MON-YYYY HH:MI:SS'), -
5 ENDTIME => TO_DATE('06-Jul-2004 17:00:00', 'DD-MON-YYYY HH:MI:SS'));

Best regards.

Frank

Report message to a moderator

Re: Options parameter in SYS.DBMS_LOGMNR.START_LOGMNR [message #62279 is a reply to message #62231]

Sat, 10 July 2004 23:48

Sami Zeitoun
Messages: 8
Registered: June 2004

Junior Member

Thanks Frank.

Report message to a moderator

Previous Topic:	Any experience with the init parameter _pga_max_size ?
Next Topic:	How to reduce the extended system.dbf

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 04:31:22 CST 2025