Re: From 8.0.5 to 8.1.5

Better refresh your memory on what in incremental export does. Incremental export exports those tables which have changed since the last complete or incremental export. Not those rows which have changed, those tables.

If few, small tables are changing, your scheme would work, provided you can stop all dml and ddl on the original database, do a final export, a final import, then switch over to the new database.

• Original Message ----- From: Adil Rahman <arahman_at_ora-tech.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, December 01, 2000 12:45 AM Subject: From 8.0.5 to 8.1.5

> Our Client is an Internet Service Provider.
> They want to switch from 8.0.5 to 8.1.5.
> My question is, what would be the best method they can adopt for this?
> They don't want to use the migration utility. And full import of their
> Database takes something like 3 days.
> I have suggested that they put 8.1.5 on a test machine and apply the full
> import on it. That way the new database would be 3 days behind the one
> running on 8.0.5. And then they can start applying the incremental exports
> on the new DB- till the time difference between the two is reduced to a
> minimum.
> Now, I don't know how correct this approach is.
> I would really appreciate if someone could help me out.
>
> thank you
>
> Adil
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Adil Rahman
> INET: arahman_at_ora-tech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Dec 01 2000 - 17:18:41 CST