Mayank, May 11, 2018 - 7:29 am UTC
Thanks for reply
But as during Import Impdp, i am coping all data from source to target without any condition , so i think below should be the case
SQL> insert into t2 select * from t1;
insert into t2 select * from t
*
ERROR at line 1:
ORA-00913: too many values
Import should throw error like in old Exp/Imp utility with error (ORA-00904: "COL3": invalid identifier ) , when there is mismatch in source and target table columns
Impdp showing successful when structure is mismatch is misleading and lot of structural error going unhanded in target
May 12, 2018 - 1:31 am UTC
Well....impdp is doing its best to obey your wishes. You said:
TABLE_EXISTS_ACTION=TRUNCATE
CONTENT=DATA_ONLY
so we're trying to copy the *data* and not the structure.
REMAP_SCHEMA=CNVABP5:cnvdbo3
Jim, May 11, 2018 - 3:29 pm UTC
I suspect that the remap_schema directive tells the import to only import the columns that match in the destination table.