Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Take this scenario:

Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle.

How to move the data and other files and attach to the new installation? In this scenario, we don't have any type of backup, neither a dump nor any other type.

share|improve this question
Possible duplicate of… – DCookie Nov 1 '10 at 17:49
What OS/Platform? – REW Nov 2 '10 at 1:10
@REW: Windows 7 OS. – RPK Nov 2 '10 at 8:03
up vote 1 down vote accepted

Check out this SF question.

share|improve this answer

Make a backup and restore it to your new Pc and make backups in the future!

share|improve this answer

The exact way, could depend on your configuration, but roughly, you could:

1) Export / Import (see documentation for exp)

2) Cold backup:

  • Make sure you have a copy of your pfile/spfile
  • Shutdown your source database
  • Copy your datafiles to the new server

There are some steps to do in between, but the advice is to consult with an oracle DBA, or read the documentation on otn

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.