Oracle database import / export

[hanselrl]

1- Install Oracle in new hardware -follow Oracle documentation.
2- Pre create databas in new hardware -follow Oracle documentation.
3- Export database from old hardware
4- FTP dump file to new hardware
5- Import dump file into new hardware.

Needless to say it will be much more easier if you get the help of a DBA

Hi,

I think this option will also work since both hardware are in Windows OS
1. Create oracle service on the new hardware (same instance name with the old hardware)
2. Do a full backup of the old db. (controlfile,datafile, initfile)
3. Restore the backup to the new hardware (must be on the same file structure)

Create also the password file on the new machine if needed.