Copy database to another computer [message #654330] |
Sat, 30 July 2016 16:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6568f7279eafd46405ad997e5835e1de?s=64&d=mm&r=g) |
derrellgore
Messages: 20 Registered: July 2016
|
Junior Member |
|
|
I am new to Oracle. I installed and created a new database...no problem.
I want to copy this database to a second computer. Can anyone tell me step by step how I can do this. Basically I want to copy the database take to anther computer which has Oracle installed and put the copy on it. So I end up with a main machine and a test machine.
And then when I have things working on TEST machine I want to be able to copy back to MAIN machine.
In Microsoft SQL I accomplish this with BACKUP/RESTORE....really easy. I haven't found away to do this in Oracle.
Thanks,
Derrell
derrellgore@windstream.net
|
|
|
|
|
|
|
|
|
|
Re: Copy database to another computer [message #654386 is a reply to message #654385] |
Mon, 01 August 2016 14:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Export:
E:\Temp\Listing>expdp help=y
Export: Release 11.2.0.4.0 - Production on Jeu. Juin 23 13:51:08 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
The Data Pump export utility provides a mechanism for transferring data objects
between Oracle databases. The utility is invoked with the following command:
Example: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
You can control how Export runs by entering the 'expdp' command followed
by various parameters. To specify parameters, you use keywords:
Format: expdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: expdp scott/tiger DUMPFILE=scott.dmp DIRECTORY=dmpdir SCHEMAS=scott
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
USERID must be the first parameter on the command line.
...
See first example (you can ignore the DIRECTORY parameter then Data Pump use the default DATA_PUMP_DIR.
Import:
E:\Temp\Listing>impdp help=y
Import: Release 11.2.0.4.0 - Production on Jeu. Juin 23 13:51:29 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
The Data Pump Import utility provides a mechanism for transferring data objects
between Oracle databases. The utility is invoked with the following command:
Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
You can control how Import runs by entering the 'impdp' command followed
by various parameters. To specify parameters, you use keywords:
Format: impdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
USERID must be the first parameter on the command line.
...
See example line.
[Updated on: Mon, 01 August 2016 14:16] Report message to a moderator
|
|
|
|
|
Re: Copy database to another computer [message #654403 is a reply to message #654388] |
Tue, 02 August 2016 04:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
Just a heads-up, the DIRECTORY parameter specified with the expdp command points to an Oracle Database Object not an O/S level file path/directory, as mentioned here.
The DBA_DIRECTORIES view will help you match up the Oracle Directory Name with its O/S counterpart.
HTH
[Edit: addendum]
[Updated on: Tue, 02 August 2016 04:38] Report message to a moderator
|
|
|
|
|