select * from
v$version;
BANNER
----------------------------------------------------------------
Oracle Database
10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release
10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux:
Version 10.2.0.5.0 - Production
NLSRTL Version
10.2.0.5.0 - Production
when i'm
trying to take full database export using DATAPUMP i got an error below:
$ expdp
directory=EXPORT dumpfile=FULL_devdb.dmp logfile=exp_FULL_devdb.log full=y
Export:
Release 10.2.0.5.0 - 64bit Production on Saturday, 06 April, 2013 16:09:04
Copyright (c)
2003, 2007, Oracle. All rights reserved.
Username: / as
sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the
Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006:
internal error
ORA-39213:
Metadata processing is not available
Then i
checked,
SQL >
SELECT comp_id, version, status FROM dba_registry;
COMP_ID VERSION STATUS
------------------------------
------------------------------ --------------------------------------------
OWM 10.2.0.5.0 VALID
CATALOG 10.2.0.5.0 VALID
CATPROC 10.2.0.5.0 VALID
JAVAVM 10.2.0.5.0 VALID
According to Metalink
ID: 402242.1,
DataPump
export uses DBMS_METADATA_UTIL package but this package does not successfully
ran. Executing sys.dbms_metadata_util.load_stylesheets procedure failed with
following error:
ORA-31609:
error loading file "kualter.xsl" from file system directory
"/rdbms/xml/xsl"
ORA-06512: at
"SYS.DBMS_METADATA_UTIL", line 1807
ORA-06512: at
line 1
Then I ran
connect / as
sysdba
SQL > execute
sys.dbms_metadata_util.load_stylesheets;
PL/SQL
procedure successfully completed.
Then my export
went successful.
0 comments:
Post a Comment