Database Transfer [message #75320] |
Wed, 12 February 2003 16:57 |
LASCOLI
Messages: 18 Registered: November 2002
|
Junior Member |
|
|
Is there a procedure to transfer all database attributes from an 8i Database running on a Solaris machine to a PC running 8i ? I am attempting to create a test enviroment on a PC , and was hoping that a method existed to do so, other than recreating all of the tables and their attributes on the PC. I would assume that I would have to ensure that the tablespace names used on the Solaris machine exist on the PC ? Thanks
|
|
|
Re: Database Transfer [message #75321 is a reply to message #75320] |
Mon, 17 February 2003 05:09 |
Kavitha
Messages: 40 Registered: December 1999
|
Member |
|
|
Hi,
You can build a test database from the existing DB in two ways:
1. Designer - Import the current DB and build a test DB setup using this - this is the best way, as you can maintain versions and different configurations and deploy them as u like
2. OEM - use Oracle Enterprise manager to create a DB using the existing DB config.
HTH
Kavitha
|
|
|