Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import for only limited columns

902923Jun 16 2015 — edited Jun 22 2015

Hi Experts,

We have two oracle database with same set up of tables with same structures but same of the tables having limited columns , like source oracle database tables has 10 columns , the same table has only 7 columns in target database.

We have exported the tables from source database with CONTENT = DATA_ONLY parameter , Now we need to import the dump in to target tables ,

But as mentioned above some of the tables has limited columns than source tables in target , is that will create a problem while importing the source dump in target tables? if yes please suggest how to resolve this? also that missed columns are Not primary key columns .

Thanks in advance,

Arun.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2015

Added on Jun 16 2015

#database-key-features, #export-import-sql-loader-external-tables

4 comments

842 views