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 question...drop and recreate schemas or table_exists_action truncate or replace

2952416Sep 1 2015 — edited Sep 3 2015

Database, 11.2.0.3.

I need to import several schemas from one database on a separate server into a database (separate server) where these schemas already exist. The target (where schemas already exist) has bad data and needs to be overwritten or replaced.

My question is...what is the better overall action plan. To drop all schemas prior to import and let Oracle create new schemas on import? Or use the table_exist_action (replace or truncate) command?

Is there any performance benefit from either action plan? Tablespaces will still exist...and are identical on Source/Target...so, I assume data will be imported correctly into Target if schema's are dropped prior to import.

Thanks for any reply/suggestions!

Chris

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2015

Added on Sep 1 2015

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

8 comments

6,393 views