IMPDP from 10.2.0.1.0 to 11.2.0.3 leads to empty tables [message #572756] |
Mon, 17 December 2012 07:20 |
|
geomac
Messages: 8 Registered: November 2012 Location: Germany
|
Junior Member |
|
|
hi
i got expd dump from 10.2.0.1.0 ORA XE database on win7 64 bit by
"expdp system/xxxx directory=DATA_PUMP_DIR dumpfile=xxx.dmp schemas=xxx EXCLUDE=STATISTICS VERSION=11.2.0.3"
the tables were exported ... no i try to import these dump into ORA enterprise 11.2.0.3 (on ora enterprise linux 64 bit) with
"impdp system/xxxx directory=DATA_PUMP_DIR dumpfile=xxx.dmp schemas=xxx TABLE_EXISTS_ACTION=APPEND"
i used that documentation: //docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm#i262317
finally schema is created.. indizies, triggers and tables are created but the tables stay / are empty....
please give me a hint.. thanks in advance
import log
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
[Updated on: Mon, 17 December 2012 08:04] Report message to a moderator
|
|
|
|
|
|
|