OraFAQ Forum: Server Utilities » Export data from table1 to import into table2

Home » RDBMS Server » Server Utilities » Export data from table1 to import into table2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic:	Question Related to Export dump file
Next Topic:	How Can I read tablespace from Oracle 8.0.5 ??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:37:01 CDT 2024