After installing the Oracle8i software on your Windows server, create a new database. This can be accomplished either through the DBCA (Database Configuration Assistant) or manually with scripts. For a step-by-step process on how to do this, review the Oracle8i Administrator's Guide Release 2
After creating this new database, create all the required application-related tablespaces that the source database currently contains. FTP the export file from your AIX server to the Windows server and uncompress it if it is in a compressed format. You can now perform an import on the Windows server, either via the command line or by first creating an import parameter file. I prefer to create a parameter file called imp.par. The contents would look similar to this:
USERID=SYSTEM FULL=y FILE=DBA.DMP GRANTS=Y INDEXES=Y
Then invoke the import utility and call the parameter file as such:
and provide a password when prompted. For more information about using import, review the Oracle8i Release 2 Utilities guide.
Review the import log to ensure that there were no errors, then run SQL on both the source and target databases to ensure that all objects were imported. Finally, note that a listener will need to be configured on the Windows server and your existing tnsnames.ora files will need to be modified to reflect where this new database resides.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.