Your steps are as follows:
- Precreate the Oracle 9i database on your Windows 2000 server. You need to create the database and create the tablespaces that will hold your data.
- On the DG server, export the entire contents of the database as
exp userid=system/manager file=dg.dmp log=dg.log full=y
- FTP the dump file to the Windows server. Make sure that the FTP is done in Binary mode.
- Import the contents of the dump file as follows:
imp userid=system/manager file=dg.log log=imp.log full=y
It's as simple as that!
This was first published in September 2004