0

impdp copies tables in the schema but data is not loaded. Same impdp command on another database works with the same dump but does not work in another database.

command used

impdp username/password@alias remap_schema=test:test_new directory=TEST_DIR dumpfile=test.dmp exclude=user logfile=test_imp.lst

This command works fine in database 1 and but for another database it succeeds but does not load data as below

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@alias remap_schema=test:test_new directory=TEST_DIR dumpfile=test.dmp exclude=user logfile=test_imp1.lst TABLE_EXISTS_ACTION=REPLACE 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/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Sun May 12 01:06:43 2019 elapsed 0 00:00:28

Note : Data is not loaded as below lines are missing in this output

. . imported "TEST"."TEST1" 7.021 MB 100000 rows

Any help in this regard is appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.