I currently have an Oracle database (9.2) on an NT server. I would like to have this db on a Unix server again. What I am hoping for is that this is a relatively simple task of exporting the database using the Oracle export tool and importing it into the same version of Oracle on a Unix server.
You are on the right track. When moving Oracle9i (or earlier) databases to a different platform, Oracle's export and import utilities are generally the way to go. First, perform a full export on your NT server:
exp userid=system/manager file=full.dmp log=full.log full=y
Then FTP the dump file to the Unix server. Make sure that you FTP in binary mode! Precreate the database on the Unix server and then import as follows:
imp userid=system/manager file=full.dmp log=imp.log full=y
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.