Re: 8.0 to 8i migration

Depending on the number of schemas with data to migrate ...

As Nick says, I pre-create the tablespaces, roles, etc.

I usually perform a rows=n export to get all triggers, procedures, indexes, etc..

I create the tables using a db link - the script is easy to create as long as you use the data dictionary (say DBA_SEGMENTS and DBA_TABLES).

After the tables are created I import the export to get the above-mentioned objects.

On Tue, 17 Apr 2001 03:15:06 GMT, Steve Siebenaler <ssiebenaler_at_cinci.rr.com> wrote:

>Nick,
>
>You must do an export/import method since you are migrating cross-platform.
>Be sure to create the tablespaces, users, roles, etc... on the target instance
>prior to running the import.
>
>Steve Siebenaler
>
>Nick Collier wrote:
>
>> Hi,
>>
>> We are migrating from 8.0 on an HP machine to 8i on a Sun, and are mulling
>> over the best way to move an actual database instance. What's the easiest
>> way to do this.
>>
>> thanks,
>>
>> Nick
>
>
>
Received on Mon Apr 23 2001 - 20:53:07 CDT