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.?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: