OraFAQ Forum: Backup & Recovery » export rows in to other table

Home » RDBMS Server » Backup & Recovery » export rows in to other table

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

export rows in to other table [message #172243]

Mon, 15 May 2006 12:19

gopikris_g
Messages: 7
Registered: March 2006

Junior Member

Hello,

Pls help me in this. We r using oracle 7.0. We have two tables with the same constraints and same structure in two different servers. I want to insert some rows into other table. What is the query, is it possible in 7.0

Thanks.

Report message to a moderator

Re: export rows in to other table [message #172250 is a reply to message #172243]

Mon, 15 May 2006 12:31

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Use export and import
http://orafaq.com/faq/import_export
Or
Use a database link to do a CTAS(More simple,if you can establish a connectivity between the two servers).

Report message to a moderator

Re: export rows in to other table [message #172251 is a reply to message #172243]

Mon, 15 May 2006 12:34

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Yes, you can:

1. Create DB link
2. INSERT INTO xxx SELECT * FROM yyy@dblink WHERE ...;

Report message to a moderator

Previous Topic:	Can I run an import without drop and recreate schema ?
Next Topic:	Backup Set Name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:24:58 CDT 2024