By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

Migrating Oracle from AIX to W2K3

P: n/a
Hi all.

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
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Søren Alexandersen wrote:
I have some specific questions on migrating a Oracle 8.1.7 database from
AIX to Windows.
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 ?
That's basically what export/import does for you. It moves all the
data, including tables, triggers, views, constraints, indicies, grants,
roles, etc. Why re-invent the wheel?

Now, you do have to install the software, create a database and create
tablespaces. But imp does just about everything else.

The nice thing about the exp/imp process is that you don't have to take
your current production system down to build and test the new instance.

What else would I need to consider before doing this migration.
Whether you should stick with 8.1.7 or upgrade as part of the migration.
[hint: you should upgrade] And if you're upgrading, whether to go to
9.2 or 10g. Given that you're going to invest several to many hours on
this, it seems silly to stay on a version that has been de-supported.
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 :-)
I'm agnostic. But fortunately, so is Oracle (more or less). The Export
..dmp files created on one OS are (purportedly) compatible with any other
OS.

I went through a WNT/8.1 -W2k3/9.2 upgrade via exp/imp a while back
and left some notes behind on c.d.o.s.
<http://makeashorterlink.com/?Z2F035C0B>
If your target version is 9.2, everything I said should apply and it
shouldn't matter that your export file came from AIX.

DISCLAIMER: I'm far from an expert here, but that has the advantage that
my "recipe" is written for another newbie. Good luck.
--
//-Walt
//
// There is no Völkl Conspiracy
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.