Export data from table1 to import into table2 [message #70155] |
Tue, 23 April 2002 00:20 |
Olivier Marcou
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi All,
I have 2 Oracle databases.
In the first database, I have a table called TABLE1 and in the second database, I have a table called TABLE2.
These 2 tables are the same, only names are different.
How can I do to export rows from TABLE1 to import them into TABLE2 ?
Thank you
Olivier
|
|
|
Re: Export [message #70157 is a reply to message #70155] |
Tue, 23 April 2002 01:27 |
Sujit Mahapatra
Messages: 19 Registered: March 2002
|
Junior Member |
|
|
Why don't you use database links?
You can easily do using an INSERT statement.
Cheers,
Sujit
-------------------------------------------
Hi All,
I have 2 Oracle databases.
In the first database, I have a table called TABLE1 and in the second database, I have a table called TABLE2.
These 2 tables are the same, only names are different.
How can I do to export rows from TABLE1 to import them into TABLE2 ?
Thank you
Olivier
|
|
|
Re: Export [message #70160 is a reply to message #70155] |
Tue, 23 April 2002 03:59 |
laxman
Messages: 14 Registered: October 2000
|
Junior Member |
|
|
Oliver,
export the table1(1st db) and import into 2nd db since they are same...
then rename it ...
I think you know how to do exp and imp..
thanks
Laxman
|
|
|