Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restoring backup
Yes, you can. Drop the user cascade that you want dropped.
and then reimport that user
imp USERID=droppeduser/pass
Wade
"Slava Pechenin" <slava_at_pechenin.ru> wrote in message
news:1067930075.69443_at_iq.wbt.ru...
> Hi,
>
> To restore backup I use the following procedure:
> 1) drop database
> 2) create database, many options, time consuming
> 3) imp.exe to import data
>
> The data backup is done as follows:
> exp USERID=user/pass BUFFER=8192 FILE=OUTPUT.DMP GRANTS=Y INDEXES=Y ROWS=Y
> CONSTRAINTS=Y COMPRESS=Y OWNER=user FEEDBACK=10 log=expo.log
>
> Restore:
> imp USERID=user/pass BUFFER=8192 FILE=OUTPUT.DMP IGNORE=N GRANTS=Y
INDEXES=Y
> ROWS=Y FULL=Y COMMIT=Y log=imp.log
>
> Can I delete all objects from database before restoring and simply import
> data with droping/creating database (i.e. skip steps 1,2)?
>
>
>
Received on Tue Nov 04 2003 - 08:02:31 CST