My Oracle Support Banner

ORA-4063 when Executing DBMS_LOGMNR_D.SET_TABLESPACE (Doc ID 577426.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


-- Problem Statement:
Setiting logminer to a specific tablespace reports the following error

SQL> create tablespace logmnr_tbs datafile '${vtbsp_dir01}/logmnr_tbs01.dbf' size 700m ;
SQL> BEGIN dbms_logmnr_d.set_tablespace('logmnr_tbs'); end;
2 BEGIN dbms_logmnr_d.set_tablespace('logmnr_tbs'); end;
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_LOGMNR_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 131
ORA-06512: at line 1


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

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