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!

Need to append data with normal exp/imp

938688Oct 23 2012 — edited Oct 25 2012

Hi,

we have a two schemas, user1 and user2, I need to take only data from user2 and have to append to user1 with the normal exp --- we do not have a direct connectivity to db server hence I can't use datapump.

can you please suggest what would be the best approach.

1. export full schema.
2. import by excluding everything except data.

or

1. export full schema by excluding everything except data
2. import the exported dump

also can you please suggest that how to export/import only data, if I mention ignore=y would that ignore all the existed objects or only tables.

Regards,
Ramesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2012

Added on Oct 23 2012

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

4 comments

3,658 views