Q

Copying a database to Windows 200x

We were using Oracle 7x then migrated to 8i. We have our applications running on NT4/Oracle 8.1.7.0.0. How do I create a replica of the same database in 9i under Win200x?

I am a database operator with experience in IT industry/manufacturing for more than nine years. We were using Oracle 7x then migrated to 8i; it has all been done by our application provider. Now the time has come to learn to do it myself. We have our applications running on NT4/Oracle 8.1.7.0.0. How do I create a replica of the same database in 9i under Win200x? I have all DBF/dmp ready. How do I start the process? What all should I do to create databases in 9i, etc.?
The easiest way to move your database to Windows 2000/2003 is to perform the following steps:

  1. Install Oracle 9i on your Windows 2000/2003 server.
  2. Use the DBCA to precreate a database on this server.
  3. Precreate any users and tablespaces you'll need in this new database.
  4. On the old database server, use Oracle's export utility to dump the entire contents of the database:
       exp userid=system file=mydb.dmp full=y
    
  5. Transfer the dump file to your new database server. If using the FTP utility, make sure your FTP is in BINARY mode.
  6. Use the import utility to ingest the dump file contents:
       imp userid=system file=mydb.dmp full=y
    
This was first published in August 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close