Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Backup/restore
Well, if you know what the changed objects are, then drop them first and use
import to re-create them.
Or am I missing something?
If you don't know what's changed, then there's not an awful lot that can help you, short of dropping all users cascade, and re-importing the entire database.
If this is a regular requirement, then you need to think of more robust mechanisms, change management and so on.
Regards
HJR
"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message
news:aen2ji$gje$1_at_reader1.imaginet.fr...
> 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
>
>
Received on Tue Jun 18 2002 - 06:37:34 CDT