Migrating Oracle from AIX to W2K3

I have some specific questions on migrating a Oracle 8.1.7 database from AIX to Windows.

I know something very similar has been asked before, but I can't seem to get some unique recommendations on where to start.

I have understood that I cannot simply copy the db-files and start up the db on the windows machine. I guess that would have been too easy, huh :-)

Well.. I get the idea about using export/import for the data part, but..

What about the table definitions ? Could I somehow on my AIX-oracle generate a script, that could create the tables on my windows-oracle ?

What else would I need to consider before doing this migration.

P.S. Please, do not begin to discuss *nix vs. windows religion here. The decision has been made... just need to know what I am about to dive into :-)

Thanks alot for any help, directions, whitepapers..whatever :-)

Regards,
Søren Alexandersen Received on Mon May 09 2005 - 15:51:29 CEST