Oracle Database Discussions

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!

update tables from one database to another

user13364377Mar 26 2011 — edited Mar 26 2011

Hi,

OS:Solaris
DB:10.2.0.4

I need to update some tables(100 tables) reside in schema TEST of Database AA with the tables that reside in schema TEST of Database BB. Both databases reside in the same server.

Both databases are having the same schema and same tables. But the table data and privileges vary.

I have to do this by truncating the tables in Database AA and then append the tables with the data from Database BB.

How to do this using truncate and append method without using Toad.

Please suggest.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2011

Added on Mar 26 2011

#general-database-discussions

10 comments

1,060 views