Expert: Elliot Mak - 5/29/2009

Question
Hi  I want to copy data from a table named (ex: EMPLOYEE) of database1 to the same table EMPLOYEE of database2.  How to do it pls help me

Answer
Good day Bhuvaneswari

There are multiple ways you can copy the data from one database to the other.  

My assumption is as follows:
Employee table structure in database 1 (DB#1) is the identical to the one in database 2 (DB#2)

Here are some options

1. Use database link to copy the data from DB#1 to DB#2
2. Write all the data to a flat file from DB#1 and import the data into DB#2 using SQLLOADER
3. Use Datapump export to export the data from DB#1, and import the data into DB#2 using datapump import.

Option #1 is by far the easiest and straightforward.

If you shall need any assistance in any of these options, please don't hesitate to let me know.

Cheers
Elliot