Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Backup/restore

Re: Backup/restore

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 18 Jun 2002 22:04:47 +1000
Message-ID: <aen7m1$l8p$1@lust.ihug.co.nz>

<Kenneth Koenraadt> wrote in message
news:3d0f1e75.18917401_at_news.capgemini.se...
> On Tue, 18 Jun 2002 12:54:06 +0200, "s Lehaire"
> <s.lehaire_at_meilleuregestion.com> wrote:
>
> >HI,
> >I've got 2 databases on 2 distincts computers.
> >I've done an export from first with the command exp and import on the
second
> >with the imp command.
> >The first database have been changed (new procedure, new fonction, modify
> >some function or procedure, new tables, change structure of table and of
> >course new data or updated data in the tables)
> >So my question is how can I import the change from the first database to
> >second one with the imp command?
> >I've tried to import but when the table( or procedure or function ) exist
it
> >don't want to import because the table( or procedure or function )
already
> >exist and the new datas (or the old ones) in the table are not createdd
(or
> >updated).
> >Thx for help
> >
> >
>
> From Oracle 8i, there is an "incremental" feature in the export
> utility, exporting only changes since the last incremental export, as
> well as a "cumulative" feature, exporting changes since last full
> export. See the documentation.

Which states that Oracle is on record as saying that incremental and cumulative exports are going to be de-supported in some future version. Not that this renders the feature invalid for use right now, of course.... but I wouldn't be banking on it as a long-term prospect.

Regards
HJR
>
> - Kenneth Koenraadt
Received on Tue Jun 18 2002 - 07:04:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US