AboutElliot Mak Expertise I can answer questions with regarding to Oracle DB (8i, 9i, 10g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).
Experience I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
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.
