EXPERT RESPONSE
Since the database is being migrated from Solaris to AIX, you cannot physically copy the database to the new server. You can choose to use Oracle's export and import utilities. This depends on much downtime you can afford. You can also create a new database on the AIX server and use CTAS (create table as select) to bring over your tables. This requires some additional post-migration work on your part to re-create the indexes, constraints, default values, etc. Export/import will do most of this for you.
If you have the option to upgrade to Oracle 10gR2, another possibility is to upgrade your database on the Solaris server and use transportable tablespaces to create a new 10g database on the AIX server. Transportable tablespaces in 10gR2 allow you to migrate across operating systems.
Be sure to review Oracle's certification matrix to ensure that you are installing Oracle database software on a certified platform.
|
