Skip to content
  • About
Search
Close

Geodata Master

Oracle Database Technical Articles & GeoSpatial Data Technology

Tag: ORA-39213 impdp

ORA-39213: Metadata processing is not available

March 5, 2014 arcsdegeoLeave a comment

if you face an error like the following while performing “impdp” operations:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit 
Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

 

Solution:

execute the following command:

SQL> exec dbms_metadata_util.load_stylesheets;

if the above query executes sucessfully then try the “impdp” command again.

other wise if you face the below:

SQL> exec dbms_metadata_util.load_stylesheets;

BEGIN dbms_metadata_util.load_stylesheets; END;
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEEXISTs failed
Permission denied
ORA-06512: at “SYS.DBMS_METADATA_UTIL”, line 1807
ORA-06512: at line 1

During dbms_metadata_util.load_stylesheets we read the directory $ORACLE_HOME/rdbms/xml/xsl and load the XSL files using DBMS_LOB package.

If the files cannot be read (most of cases by missing rwx privileges for oracle user), then we raise the errors above.

Re-load the stylesheets using the dbms_metadata_util.load_stylesheets procedure after the permission issue is solved and then retry DataPump import (impdp).

you may need to install Install JVM and XML components.

Blog Stats

  • 485,439 hits

Recent Posts

  • Oracle datapatch error PLS-00201: identifier ‘DBMS_LOB’
  • Oracle 19c upgrade Errors ORA-04067: not executed, package body “MDSYS.MDPRVT_IDX” does not exist
  • Oracle 19c upgrade error ORA-40362: invalid object SYS.ODCIPARTINFOLIST specified in the statement
  • Steps to Create your Oracle Cloud ATP
  • Oracle PDB and when is DAPTATCH required to be executed
Follow Geodata Master on WordPress.com

Top Posts & Pages

  • Oracle Database Product Life Cycle Support 19c,18c, 12cR2 Long Term & Innovation Releases !
  • Performing Import Data Pump with EXCLUDE=STATISTICS
  • What does datapatch do ?
  • RMAN List Backup Summary command
  • Oracle PSU July 2018 error - ORA-20001: Latest xml inventory is not loaded into table
  • revoking a tablespace quota from user
  • set define off and '&' in your SQL Code
  • sqlplus error for Oracle 12c in IBM AIX : rtld: 0712-001 Symbol CreateIoCompletionPort was referenced
  • ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine ORA-20085: Insert Spatial Reference SRID 4326 does not match SDE.GDB_ITEMS.SHAPE registered Spatial Reference SRID 0 ORA-06512: in "SDE.ST_DOMAIN_METHODS", line 2000
  • INHERIT PRIVILEGES in Oracle 12c

Archives

  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • April 2020
  • March 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013

Recent Comments

Jack on Oracle Database Lost Write Det…
Unified Audit Trail… on ORA-55940: An error occurred d…
Rasel Parvej on ORA-00904: “ACDRROWTSINT…
Wendy on Oracle SYSAUX size is exponent…
Reda Ali on Oracle 19c – Oracle Spat…

Search in my blog

Follow Geodata Master on WordPress.com

Top Posts & Pages

  • Oracle Database Product Life Cycle Support 19c,18c, 12cR2 Long Term & Innovation Releases !
  • Performing Import Data Pump with EXCLUDE=STATISTICS
  • What does datapatch do ?
  • RMAN List Backup Summary command
  • Oracle PSU July 2018 error - ORA-20001: Latest xml inventory is not loaded into table
  • revoking a tablespace quota from user
  • set define off and '&' in your SQL Code
  • sqlplus error for Oracle 12c in IBM AIX : rtld: 0712-001 Symbol CreateIoCompletionPort was referenced
  • ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine ORA-20085: Insert Spatial Reference SRID 4326 does not match SDE.GDB_ITEMS.SHAPE registered Spatial Reference SRID 0 ORA-06512: in "SDE.ST_DOMAIN_METHODS", line 2000
  • INHERIT PRIVILEGES in Oracle 12c

Blog Stats

  • 485,439 hits

Archives

  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • April 2020
  • March 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
Blog at WordPress.com.
Back to top