Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Imports and Rollback
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
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Oct 27 1999 - 08:37:55 CDT