| question about data copy [message #68603] |
Wed, 07 April 2004 00:27  |
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  |
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 |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
