OraFAQ Forum: Server Administration » Experimenting with the continous log mining

Home » RDBMS Server » Server Administration » Experimenting with the continous log mining (Oracle 10g)

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

Experimenting with the continous log mining [message #306163]

Thu, 13 March 2008 01:40

priyamalhotra
Messages: 43
Registered: July 2006
Location: none

Member

Hi,

This is with reference to article:
Experimenting with the continous mining (http://www.orafaq.com/node/1378)

During the execution of

BEGIN
dbms_Logmnr.Start_Logmnr(StartTime => SYSDATE - 1 / 24, Options => dbms_Logmnr.dict_From_OnLine_Catalog + dbms_Logmnr.Continuous_Mine);
END;

I came across error dbms_Logmnr.dict_From_OnLine_Catalog must be declared.
So I executed,
@dbmslmd.sql
@dbmslm.sql
@prvtlm.plb
@prvtlmd.plb
@prvtlmrd.plb

But still the problem persists stating error:
PL/SQL ICD vector missing for this package

Kindly assist what needs to be followed further.

Thanks,
Priya.

Report message to a moderator

Re: Experimenting with the continous log mining [message #306170 is a reply to message #306163]

Thu, 13 March 2008 02:02

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you have the privilege to execute the package?

Regards
Michel

Report message to a moderator

Re: Experimenting with the continous log mining [message #306407 is a reply to message #306170]

Fri, 14 March 2008 02:11

priyamalhotra
Messages: 43
Registered: July 2006
Location: none

Member

Hi,

The user has granted execute on package to all.

Please provide the query or table name to verify that the user is having execute privilege on the package.

Thanks,
Priya.

Report message to a moderator

Re: Experimenting with the continous log mining [message #306420 is a reply to message #306407]

Fri, 14 March 2008 02:39

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Query user_tab_privs.

Regards
Michel

Report message to a moderator

Re: Experimenting with the continous log mining [message #306450 is a reply to message #306420]

Fri, 14 March 2008 05:18

priyamalhotra
Messages: 43
Registered: July 2006
Location: none

Member

Hi,

The output I received after querying user_tab_privs is:

GRANTEE -> OWNER -> TABLE_NAME -> GRANTOR -> PRIVILEGE -> GRANTABLE -> HIERARCHY
------------------------------------------------------------------------------------------------------------------------------------
EXECUTE_CATALOG_ROLE -> USER1-> DBMS_LOGMNR -> USER1 ->EXECUTE-> NO -> NO

One thing that can be seen is that the owner is same as the grantor.

So even the execute privilege is also not required.

Also please tell me how do I paste the output with formatting, As when I paste after copying from PLSQL Developer, Notepad, MSWORD, MSEXCEL, HTML none of them formats it properly.

Thanks,
Priya.

Report message to a moderator