Home » RDBMS Server » Server Administration » Experimenting with the continous log mining (Oracle 10g)
icon6.gif  Experimenting with the continous log mining [message #306163] Thu, 13 March 2008 01:40 Go to next message
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.


Re: Experimenting with the continous log mining [message #306170 is a reply to message #306163] Thu, 13 March 2008 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have the privilege to execute the package?

Regards
Michel
icon6.gif  Re: Experimenting with the continous log mining [message #306407 is a reply to message #306170] Fri, 14 March 2008 02:11 Go to previous messageGo to next message
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.

Re: Experimenting with the continous log mining [message #306420 is a reply to message #306407] Fri, 14 March 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query user_tab_privs.

Regards
Michel
icon6.gif  Re: Experimenting with the continous log mining [message #306450 is a reply to message #306420] Fri, 14 March 2008 05:18 Go to previous messageGo to next message
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.

Re: Experimenting with the continous log mining [message #306466 is a reply to message #306450] Fri, 14 March 2008 07:16 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_LOGMNR should be ownned by SYS and not another user.

Quote:
please tell me how do I paste the output with formatting

OraFAQ Forum Guide, "How to format your post?" section.
See SQL Formatter
Use code tags, see ./fa/4010/0/ button.

Regards
Michel
Previous Topic: opatch requirement
Next Topic: Migrating Database from Windows to Linux
Goto Forum:
  


Current Time: Wed Dec 07 16:17:03 CST 2016

Total time taken to generate the page: 0.08345 seconds