Hello,
i tried to do this as described:
EXPORT:
mkdir /usr/lib/oracle/DUMP_DIR
chown -R oracle:dba /usr/lib/oracle/DUMP_DIR
DUMP_DIR=/usr/lib/oracle/DUMP_DIR
export DUMP_DIR
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus sys/<passwd> as sysdba @gen_inst.sql
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus sys/<passwd> as sysdba @export_data.sql
expdp system/<passwd> full=Y EXCLUDE=SCHEMA:\"LIKE \'APEX_%\'\",SCHEMA:\"LIKE \'FLOWS_%\'\" directory=DUMP_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
expdp system/<passwd> TABLES=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$ directory=DUMP_DIR dumpfile=DB10G2.dmp logfile=expdpDB10G2.log
export_data.sql:
CREATE DIRECTORY DUMP_DIR AS '/usr/lib/oracle/DUMP_DIR';
GRANT read, write ON DIRECTORY DUMP_DIR TO system;
QUIT
This worked, the files are generated.
IMPORT:
mkdir /u01/app/oracle/DUMP_DIR
chown -R /u01/app/oracle/DUMP_DIR
chmod 640 /u01/app/oracle/DUMP_DIR/*.dmp
chmod 644 /u01/app/oracle/DUMP_DIR/*.log
DUMP_DIR=/u01/app/oracle/DUMP_DIR
export=DUMP_DIR
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus sys/<passwd> as sysdba @import_data.sql
/u01/app/oracle/product/11.2.0/xe/bin/impdp system/<passwd> full=Y directory=DUMP_DIR dumpfile=DB10G.dmp logfile=expdpDB10G1.log
/u01/app/oracle/product/11.2.0/xe/bin/impdp system/<passwd> directory=DUMP_DIR TABLE_EXISTS_ACTION=APPEND TABLES=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$ dumpfile=DB10G2.dmp logfile=expdpDB10G1b.log
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus sys/<passwd> as sysdba @install.sql
import_data.sql:
CREATE DIRECTORY DUMP_DIR AS '/u01/app/oracle/DUMP_DIR';
GRANT read, write ON DIRECTORY DUMP_DIR TO system;
QUIT
After the two impdp commands i got two errors:
ORA-39006 internal error
ORA-39213 Metadata processing is not available
What's the solution?
Best regards
AK