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

Last updated on OCTOBER 28, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms