zmuszanie Oracle XE expdp ( DataPump ) do dzialania…

Post z dnia: 15/12/2006

mimo CREATE OR REPLACE DIRECTORY + odpowiednich grantow dla siebie ( user/schema : vnull ) dalej mi DataPump nie ruszyl:

oracle@xeno:~$ expdp vnull/BLEBLEBLE@XE schemas=vnull directory=expdp1_dir dumpfile=vnull.dmp logfile=expdpVNULL.log
[..]
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
ORA-39006: internal error
ORA-39213: Metadata processing is not available

Rozwiazaniem niby ma byc:
Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
Tylko ze podczas odpalania tej procedury okazalo sie ze moja Oracle XE nie ma tych stylesheetow. Jako ze mam na rowni z XE zainstalowane Oracle Enterprise Edition to nie bylo problemow z:
oracle@xeno:~$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/
oracle@xeno:~/app/oracle/product/10.2.0/server/rdbms$ ls
admin audit demo install jlib label.info log mesg public
oracle@xeno:~/app/oracle/product/10.2.0/server/rdbms$ ln -s /u01/product/10.2.0/db_1/rdbms/xml .
oracle@xeno:~/app/oracle/product/10.2.0/server/rdbms$ ls -al| grep -i xml
lrwxrwxrwx 1 oracle oinstall 34 Dec 15 15:33 xml -> /u01/product/10.2.0/db_1/rdbms/xml
oracle@xeno:~/app/oracle/product/10.2.0/server/rdbms$ sqlplus / as sysdba

[..]

SQL> execute dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.
oracle@xeno:~/app/oracle/product/10.2.0/server/rdbms$ expdp vnull/BLEBLEBLE@XE schemas=vnull directory=expdp1_dir dumpfile=vnull.dmp logfile=expdpVNULL.log

[..]

Dump file set for VNULL.SYS_EXPORT_SCHEMA_01 is:

/u01/expdp1/vnull.dmp

Job “VNULL”.”SYS_EXPORT_SCHEMA_01″ successfully completed at 15:35:01

Comments are closed.