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!

Data import- truncate table if it exists.

913578May 15 2012 — edited May 15 2012

Hi,

There are two databases, A and B.

I am importing some tables data from A to B in some queries using dblink.

There may be chances of existing table names importing in B database as well, If the tables exists in B then truncate it and replace with the data coming from A.

please give me some option to work this.

Thanks,
Vinod

Edited by: 910575 on May 15, 2012 3:13 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 12 2012

Added on May 15 2012

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

4 comments

1,235 views