Re: Export compatibility

"Tim Smith" <timasmith_at_hotmail.com> wrote in message news:a7234bb1.0301191205.7063d7f1_at_posting.google.com...
> Oh I also wanted to ask, with high volume Oracle 7.3 databases is it
> possible to do an incremental export to reduce the downtime of waiting
> for the import
> i.e. is it completely safe.

There *is* an incremental export feature, but there's a catch: it's incremental at the OBJECT level. So if you export EMP on Monday (let's say), modify one of the 3,000,000 records in that table on Tuesday, and do an incremental export of EMP on Wednesday, then the entire set of 3,000,000 rows goes into Wednesday's export file... not just the one new row. And that probably is not what you were after (but it's all we've got!).

Incremental/Cumulative exports are also deprecated by Oracle, who've announced plenty of times that the feature will be disappearing in the near future, but that may not be an issue for you since you are already using a de-supported version of the database. But if you were planning a migration to 9i etc sometime soon, bear in mind that if you knock up some fabulous administrative process that relies on incremental exports, one day they'll break.

Regards
HJR
>
> Tim
>
>
> timasmith_at_hotmail.com (Tim Smith) wrote in message
news:<a7234bb1.0301190726.86adee5_at_posting.google.com>...
> > Hi,
> > I have a production database on 7.3.2.1 AIX 4.2.1 on an RS/6000
> > which has an export size of 10GB compressed.
> > New IBM hardware is on its way and the goal is to move the data
> > into an Oracle 8.1.7.1 database, not sure about AIX - maybe 4.3, maybe
> > 5.
> > I could (with existing CDs) build a 7.3 database, import and then
> > upgrade in place - but is this necessary - are the exports fully
> > compatible between Oracle versions?
> >
> > thanks
> >
> > Tim
Received on Sun Jan 19 2003 - 21:04:32 CST