We're currently running 2 Oracle8 instances in a HP-UX unix environment. We're required to move to a Windows 2000 server and upgrade our database version to Oracle9i. I have not worked with Oracle on windows platform before. I do have a help of our network admn in installing Oracle. I have been reading about the new features of Oracle 9i and how we do not have svrmgr or internal user id. I have gone through the Oracle documentation that comes with the CD.

I know i would have to use export/import method here. Do i have to create the exact same file structure as my unix enviroment to do the import in the new environment? Can I change the table structures of the existing tables when i import them into our new OS? Could anyone guide me through some steps that would make this installation problem-less.

Thank you so much for your time,