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

Home -> Community -> Usenet -> c.d.o.server -> Restoring backup

Restoring backup

From: Slava Pechenin <slava_at_pechenin.ru>
Date: Tue, 4 Nov 2003 09:14:34 +0200
Message-ID: <1067930075.69443@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 - 01:14:34 CST

Original text of this message

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