DBMS_LOGMNR_D.build Command Fails With "ORA-29280: invalid directory object"
(Doc ID 3002362.1)
Last updated on MARCH 16, 2024
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Creating dictionary file for logminer fails with following error:
"ORA-29280: invalid directory object"
SQL> BEGIN
sys.DBMS_LOGMNR_D.build (
dictionary_filename => 'lgmnrdict.ora',
dictionary_location => 'logmnrarchive_dir');
END;
/
2 3 4 5 6 BEGIN
*
ERROR at line 1:
ORA-29280: invalid directory object
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 38
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 33
ORA-06512: at line 2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |