Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Backup/restore
<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