impdp imports all tables with same name
Hi,
We have a database where multiple users have the same table names and they are all the same layout. When I try to import into the tables for 1 schema it overlays all the users. This is the command I use:
impdp scott/password DIRECTORY=DATA_PUMP_DIR1 DUMPFILE=CONV1_export_110106.dmp TABLES=curcval,cubcnvt,curcnvt TABLE_EXISTS_ACTION=truncate LOGFILE=impdp_scott_tables_01072010.log
Any suggestions to prevent the other tables from being overlayed?
Thanks,
Eric.
We have a database where multiple users have the same table names and they are all the same layout. When I try to import into the tables for 1 schema it overlays all the users. This is the command I use:
impdp scott/password DIRECTORY=DATA_PUMP_DIR1 DUMPFILE=CONV1_export_110106.dmp TABLES=curcval,cubcnvt,curcnvt TABLE_EXISTS_ACTION=truncate LOGFILE=impdp_scott_tables_01072010.log
Any suggestions to prevent the other tables from being overlayed?
Thanks,
Eric.
0