Re: Migrate Oracle 7.3.2.1 from VMS to AIX

Hi,
I suppose you have at least 8.1.7.x Oracle at your AIX RS/6000. Without any informations about your database design, I think you should consider :

1. do not use sqlnet/listener to replicate any tables for a such migration procedure, especially when you have 2Go tables.
2. use export/import method
3. do preparations as complete as possible, I don't know if you talk about a production database. many facteurs are to be considered during a migration : what are the complexity of your database (use of constraints, trigger, crossing-grant etc) ?
4. consider also your backup method and the time.

HTH
G. Yang
Oracle DBA.

"Tim Smith" <timasmith_at_hotmail.com> wrote in message news:a7234bb1.0203270754.4e276ba7_at_posting.google.com...
> Hi,
>
> It never rains but it pours. Does anyone have general experience or
> recommendations on the feasibility of moving a 200GB Oracle 7.3.2.1
> database from a Compaq Alphaserver to an IBM AIX RS/6000. I have
> experience on both platforms as a system admin and have general Oracle
> experience.
>
> I cannot backup any datafiles as they will be completely incompatible.
>
> I could export/import static tables.
>
> Some tables are > 2GB and have 1 insert/second so I feel exporting
> those will probably not work.
>
> Perhaps I can use [SQL]+listener+[table primary key] to replicate the
> table across domains.
>
> thanks!
>
> Tim
Received on Wed Mar 27 2002 - 12:25:18 CST