SQLERRM=ORA-20000: Only SYS can invoke this callout routine Or PLS-00201: identifier 'SYS.SDO_RDF_EXP_IMP' must be declared (Doc ID 1430758.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms


While executing a Full export data pump in a database with Semantics installed we get errors:

$ expdp system/manager DIRECTORY=DIR DUMPFILE=full.dmp LOGFILE=my_logdir full=y

Connected to: Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/********
DIRECTORY=DIR DUMPFILE=full.dmp LOGFILE=my_logdir full=y
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."SDO_RDF_EXP_IMP".SYSTEM_CALLOUT(0,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1749
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.SDO_RDF_EXP_IMP' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored



$ expdp \'/ as sysdba\' DIRECTORY=DIR DUMPFILE=full.dmp LOGFILE=my_logdir full=y

Connected to: Oracle Database 11g Enterprise Edition Release
11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_04": "/******** AS SYSDBA"
DIRECTORY=DIR DUMPFILE=full.dmp LOGFILE=my_logdir full=y
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."SDO_RDF_EXP_IMP".SYSTEM_CALLOUT(0,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1749
ORA-20000: Error during callout:
SQLERRM=ORA-20000: Only SYS can invoke this callout routine
[
ORA-06512: at "SYS.SDO_RDF_EXP_IMP", line 47
]



When the export is executed with a non-sys user the error is:

PLS-00201: identifier 'SYS.SDO_RDF_EXP_IMP' must be declared

When is is executed as '/ as sysdba' the error is:

SQLERRM=ORA-20000: Only SYS can invoke this callout routine

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