Tag Info

New answers tagged


Just import your data into a a staging table at the target database. Then write a SQL staement to copy the rows from the staging table into the target table while giving the two new columns an explicit value. So something like this; The following syntax should work on 11g impdp user/password directory=import_directory dumpfile=data.dmp ...

Top 50 recent answers are included