hi
we are trying to fork lift a table from 11g db on solaris to 11g db on linux using expdp and impdp. import creates the table structure and completes successfully.
-rwxrwxr-x 1 dbaproj dbaproj 4.0K Oct 5 21:24 expdp_ARIBA.CXMLDOCUMENTTAB_aridw9p1_4oct_201.dmp
-rwxrwxr-x 1 dbaproj dbaproj 4.0K Oct 5 21:24 expdp_ARIBA.CXMLDOCUMENTTAB_aridw9p1_4oct_301.dmp
-rwxrwxr-x 1 dbaproj dbaproj 442G Oct 5 21:48 expdp_ARIBA_CXMLDOCUMENTTAB_aridw9p1_4oct_101.dmp
Import command:
directory=ARIBA dumpfile=expdp_ARIBA_CXMLDOCUMENTTAB_aridw9p1_4oct_1%U.dmp,expdp_ARIBA.CXMLDOCUMENTTAB_aridw9p1_4oct_2%U.dmp,expdp_ARIBA.CXMLDOCUMENTTAB_aridw
9p1_4oct_3%U.dmp logfile=log_imp_expdp_ARIBA_CXMLDOCUMENTTAB_aridw9p1_4oct_101.log table_exists_action=replace
Log :
$ more log_imp_expdp_ARIBA_CXMLDOCUMENTTAB_aridw9p1_4oct_101.log
;;;
Import: Release 11.2.0.4.0 - Production on Thu Oct 6 05:40:07 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "KY690"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "KY690"."SYS_IMPORT_FULL_01": ky690/******** parfile=impdp.par
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job "KY690"."SYS_IMPORT_FULL_01" successfully completed at Thu Oct 6 05:40:24 2016 elapsed 0 00:00:04