Re: Can I turn off the rollback function?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 26 Aug 1999 22:02:09 +0200
Message-ID: <935697763.19214.0.pluto.d4ee154e@news.demon.nl>

No,
you can't turn off rollback, as that will disable one of the essences of databases.
You can however run your import with COMMIT=Y. This will make sure as soon as BUFFER bytes have been written, a commit is issued, thus allowing for smaller rollback segments. IMO, you should revise your rollback segments also anyway.

Hth,

Sybrand Bakker, Oracle DBA

Yan Zhou <yanzhou_at_cbgbcs.cb.lucent.com> wrote in message news:7q43to$i28_at_nntpa.cb.lucent.com...
> Hi I've been having some problems importing large tables because of the
max#
> of extents being reached or some other things. Does anyone know if I can
> turn off the rollback completely by like changing certain parameters or
> something.
> Is that possible?
>
> Thanks,
> Yan
>
>
Received on Thu Aug 26 1999 - 15:02:09 CDT