Home » RDBMS Server » Enterprise Manager » question about data copy
question about data copy [message #68603] Wed, 07 April 2004 00:27 Go to next message
zhebincongzhebincongzhebi
Messages: 5
Registered: March 2004
Junior Member
hello
i have two oracle9is,both of them have a same table,but one table is full,that is there are records in it.the other one is empty,i want to copy these records in the full table to the empty table in other oracle9i,how can i do?

thank you
Re: question about data copy [message #68605 is a reply to message #68603] Wed, 07 April 2004 06:00 Go to previous messageGo to next message
Rama Chandra Prasad
Messages: 3
Registered: April 2004
Junior Member
Hi,

Any one of the following options can be used

1) Export the table in database1, Import the same in database2

2) Create database link between both the databases.
Insert into empty table using the database link
Re: question about data copy [message #68607 is a reply to message #68605] Wed, 07 April 2004 17:18 Go to previous messageGo to next message
zhebincongzhebincongzhebi
Messages: 5
Registered: March 2004
Junior Member
thanks for your help
suddenly,i think of another problem,the method 1 and 2 can works well to the tables with the same struture,but if the source table and the destination table are different in the structure,only have some common COLUMNS,how can i copy the columns from the source to the destination?
Re: question about data copy [message #68608 is a reply to message #68607] Wed, 07 April 2004 19:55 Go to previous message
Rama Chandra Prasad
Messages: 3
Registered: April 2004
Junior Member
Hi...

For this method 2 can be used.

Let's assume table 1 has five columns like column1, column2, column3, column4, column5 and it has records. Table2 has only two similar columns of table1 that is column1 and column3.

Create database link between these two databases.

Connect to database1. Issue the following statement.
Insert into table2@db2 select column1, column3 from table1.
Previous Topic: OEM Performance Manager
Next Topic: Oracle Installation Quits Without Error Message
Goto Forum:
  


Current Time: Wed May 18 18:23:40 CDT 2022