I have an "Oracle 7 Server release 188.8.131.52.0 - Production Release" database on a DG/UX Machine. I wish to migrate that to Oracle 9i on a Windows 2000 machine. Please help me and guide me as to what sequence of actions I should take to make that happen.
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 follows:
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!
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.