How to copy an Oracle database to another server
Hi,
I would like to set up a test environment for an Oracle 9i database. What is the easiest way to copy the database to the test server? Please note that the production server has different hard drive structure. I.E, the production server has data files on c, d, e, f drives but there is only a C drive on test server.
Thanks in advance,
Celia
failed to create control file
Thanks for the advice to copy Oracle database.
However when trying to create a control file, I had error 01161. Seems that the new database on the test server will have to have exact db_name and global database name as the production database. So my question is will this have any impact on the production database at all? I mean any naming conflict?