I have tried to use LogMiner. But I got an error message. Could you please send me the steps to solve this problem?
SQL> DESCRIBE DBMS_LOGMNR_D PROCEDURE BUILD Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- DICTIONARY_FILENAME VARCHAR2 IN DICTIONARY_LOCATION VARCHAR2 IN SQL> SELECT STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME ='DBMS_LOGMNR_D'; STATUS ------- VALID VALID SQL> insert into scott.emp1 2 values (7777, 'Henry', 'cleark', 7566, '19-APR-87', 9999,0,30); 1 row created. SQL> commit; Commit complete. SQL> connect system/manager Connected. SQL> connect system/manager@db03 Connected. SQL> connect system/manager@db03 Connected. SQL> connect system/manager@db03 as sysdba Connected. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount pfile='c:oracleadmindb03pfileinit.ora ORACLE instance started. Total System Global Area 73701404 bytes Fixed Size 75804 bytes Variable Size 56770560 bytes Database Buffers 16777216 bytes Redo Buffers 77824 bytes Database mounted. SQL> EXECUTE DBMS_LOGMNR_D.BUILD ('DB03DICT.ORA', 'C:ORACLELM'); BEGIN DBMS_LOGMNR_D.BUILD ('DB03DICT.ORA', 'C:ORACLELM'); END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_LOGMNR_D.BUILD' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Your problem is that the LogMiner packages are owned by SYS. And there are no public privileges for this package. You signed on to the database as SYSTEM. Sign on as SYS and try again.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.