Re: Imports and Rollback

Warning warning Will Robinson!

A couple of comments on Connor's comment. One is the usual DON'T DO THIS warning from Oracle Support, even though I'm not part of it. The underscore (or underbar as they call it here in the US for some reason) parameters are not supported unless Oracle Support gets involved.

Second comment is that the parameter Connor mentions affects redo, not rollback, so it won't help in this case anyway.

HTH. Pete

Connor McDonald wrote:

> Sybrand Bakker wrote:
> >
> > I guess the answer would be no and no.
> > You can however include
> > commit=y
> > on the commandline.
> > This will assure a commit occurs whenever the complete buffer= bytes have
> > been inserted.
> >
> > Hth,
> >
> > --
> > Sybrand Bakker, Oracle DBA
> > Frank Siegel <NorthernSnow_at_worldnet.att.net> wrote in message
> > news:7v4kjh$ccj$1_at_bgtnsc02.worldnet.att.net...
> > >
> > > Thank you in advance for any help you may give.
> > >
> > > Can an import be done without the use of rollback? Can you please answer
> > > this question with Oracle 7.3.4 and 8.05 in mind? I had to add a
> > > datafile to my rollback segment tablespace during an import so it would
> > not
> > > bomb.
> > >
> > > By the way, the export came from Oracle 7.3.4 and went to 8 if that has
> > > anything to do with it.
> > >
> > > Thanks again,
> > > Frank
> > > New Hampshire
> > >
> > >
>
> There is (or used to be) a _disable_logging parameter which could be
> used as long as you were happy to lose the lot if anything went wrong
> during the import. We commonly used to it to speed up the refresh of
> test databases
>
> Cheers
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."

Received on Wed Oct 27 1999 - 17:16:05 CDT