My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.