Re: Restoring backup

"Wade Noordink" <noordinkw_at_bellsouth.net> wrote in message news:<bjOpb.32465$SV2.7192_at_bignews3.bellsouth.net>...
> 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)?
> >
> >
> >

The user should be recreated after a drop cascade and granted the appropriate privileges.It is advisable to use compress=no so you do not create one very large extent as a result of the export.The buffer could be a lot larger than the chosen value for faster exports or choose direct=y, a feedback of 10 will mean a one million row table will produce a 100000 dots except you have tables with very few rows in your case

Note schema privileges
Export Schema(User)
Drop schema
Recreate schema with appropriate privileges import schema
You may check out http://www.oracledba.co.uk/ ----super fast imports

Michael Tubuo Ngong Received on Tue Nov 04 2003 - 12:45:47 CST