Home » RDBMS Server » Server Utilities » Export/Import of the database on one server to database on another server (Oracle 9i, HP-UX)
icon4.gif  Export/Import of the database on one server to database on another server [message #347933] Mon, 15 September 2008 02:05 Go to next message
sanei05
Messages: 103
Registered: September 2008
Senior Member
Hi,

I have a large database(production)DB1 on one of the server and I need to export the whole database DB1 to another database DB2 on another production server. Both are in the mutimaster replication environment. Can anyone suggest me how to export the database Db1 and import to DB2.

Note: both are installed on 2 different Servers


Urgent Please.
Re: Export/Import of the database on one server to database on another server [message #347956 is a reply to message #347933] Mon, 15 September 2008 03:23 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not familiar with the "mutimaster replication environment", but both full export and import are quite straightforward.

This is the Utilities 10g book; you haven't mentioned your database version so - if necessary, search for another document at http://tahiti.oracle.com.

If possible, use Datapump. If not, check chapter 19: Original Export and Import.
Re: Export/Import of the database on one server to database on another server [message #347962 is a reply to message #347956] Mon, 15 September 2008 03:41 Go to previous messageGo to next message
sanei05
Messages: 103
Registered: September 2008
Senior Member
I am using oracle 9i Release 9.0.1.0.1
Re: Export/Import of the database on one server to database on another server [message #347972 is a reply to message #347962] Mon, 15 September 2008 04:08 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, then you'll use Export and Import utilities.
Re: Export/Import of the database on one server to database on another server [message #347975 is a reply to message #347972] Mon, 15 September 2008 04:16 Go to previous messageGo to next message
sanei05
Messages: 103
Registered: September 2008
Senior Member
can i have the steps....pls
Re: Export/Import of the database on one server to database on another server [message #347984 is a reply to message #347975] Mon, 15 September 2008 04:38 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle9i Database Utilities

Regards
Michel
Previous Topic: import/export options
Next Topic: Export log error
Goto Forum:
  


Current Time: Mon Dec 05 15:03:24 CST 2016

Total time taken to generate the page: 0.13632 seconds