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 10.2.0.3 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.

Symptoms

-- 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:
"SYS.DBMS_LOGMNR_INTERNAL"
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 131
ORA-06512: at line 1




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

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