Copying a database to a new instance [message #63327] |
Mon, 27 September 2004 11:57 |
Joe Cohen
Messages: 3 Registered: May 2003
|
Junior Member |
|
|
I've created a new instance of Oracle. I want to copy the database in the old instance to the new instance. How best to do this ? (Linux Server, Oracle 10g)
|
|
|
Re: Copying a database to a new instance [message #63331 is a reply to message #63327] |
Mon, 27 September 2004 20:08 |
TANMAIYEE
Messages: 5 Registered: September 2004
|
Junior Member |
|
|
Assuming you older database is 9i
If the old database is small size... export from it and import into new which should work fine. For larger DBs in 10g, use Transportable tablespaces to bring the complete data TS.
The question is unclear....
|
|
|