OraFAQ Forum: SQL & PL/SQL » how to copy data from one DB to another DB

Home » SQL & PL/SQL » SQL & PL/SQL » how to copy data from one DB to another DB

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

how to copy data from one DB to another DB [message #224019]

Mon, 12 March 2007 12:02

sherya
Messages: 11
Registered: February 2007
Location: noida, sec-15

Junior Member

hello all

can u plz tell me how could one copy data from one database to another database ?

atleast give me some hints .
i will be highly oblige if any one could solve it out.

regards

Report message to a moderator

Re: how to copy data from one DB to another DB [message #224022 is a reply to message #224019]

Mon, 12 March 2007 12:22

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Export / Import would be one way. Please look at the documentation at http://tahiti.oracle.com or do a search.

Report message to a moderator

Re: how to copy data from one DB to another DB [message #224160 is a reply to message #224019]

Tue, 13 March 2007 05:40

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What version of the database?

As joy_division mentioned, export/import is an option as is database link. If you are on 10g, you can consider data pump.

Report message to a moderator

Previous Topic:	Help with a Query
Next Topic:	Multiple/Single Line Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 01:45:09 CST 2024