12c Transprotable Tablespace issue

From: goran bogdanovic <goran00_at_gmail.com>
Date: Tue, 31 May 2016 17:43:37 +0200
Message-ID: <CAGyPXK64UX+6KZiNHQG4fb3JizZ0xpNWy0r7q3VZP9xK0M-U_g_at_mail.gmail.com>



Hi,

Environment is 12.1.0.2, transporting tablespace from PDB into non-CDB raises an error (see below).
If someone has already faced that issue, would appreciate willingness for sharing possible solution/workaround.
IMO error message is misleading, package SYS.DBMS_REPCAT_UTL is OK.

Thanks,
Goran

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SYS_at_ag1> _at_impscrpt.sql

Directory created.

Directory created.

DECLARE
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REPCAT_UTL"

ORA-06512: at "SYS.DBMS_STREAMS_TBS_INT", line 401
ORA-06512: at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 119
ORA-06512: at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 1672
ORA-06512: at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 1831
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called:

"SYS.DBMS_REPCAT_UTL"

ORA-06512: at line 22

Directory dropped.

Directory dropped.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 31 2016 - 17:43:37 CEST

Original text of this message