Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Restoring backup
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