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.


Check out this SF question.


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


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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