We are moving from an old server to a new, larger server. I have a 8.0.5 database which is about 20 GB. Can you recommend the best way to move this file over?

    Requires Free Membership to View

When moving from one physical server to another, one of the best ways to perform this operation is to use Oracle's Export and Import utilities. By using exp and imp, you can enjoy these benefits:

  1. You can go from one OS platform to another; for instance the old db server could be Sun Solaris and the new one can be Linux.
  2. You can upgrade at the same time. Create a dump file with your Oracle 8.0.5 software. Then use Oracle 10g's imp utility to import into your new 10g database on the new db server. The database will be upgraded in this step.
  3. You can perform any database reorganizations you need to do at the same time.
  4. You can change the DB_BLOCK_SIZE if needed at this time.

The downside to using exp and imp is that a larger database can take a long time to import. However, 20GB is not that large of a database so I would probably use exp and imp for my database move to the new server. Use these steps:

  1. On the new db server, install the Oracle software and precreate any tablespaces you'll need.
  2. Optionally, precreate any users you'll need in the new database.
  3. On the old database server, take a full export of your database:
       exp userid=system/manager file=full.dmp log=exp.log full=y
    I always log my session's output for reference.
  4. FTP the dump file to the new database server in binary mode.
  5. Import the dump file's contents on the new database server:
       imp userid=system/manager file=full.dpm log=imp.log full=y

That should complete your move!

This was first published in October 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: