Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please a parameter to disable undo, like _disable_logging

RE: Please a parameter to disable undo, like _disable_logging

From: John Clarke <jclarke_at_centroidsys.com>
Date: Tue, 5 Oct 2004 23:33:36 -0400
Message-ID: <20041005233336.6d9a082c@centroidsys.com>


/*+ append */ disables redo, not undo (as does =5Fdisable=5Flogging).

Array/bulk inserts will reduce the amount of undo you generate, so this = method will help. But you can't avoid undo altogether.

At least you're not updating or deleting the 10,000,000 rows.

John

> thanks

>=20
> but /*+ append */ too bypasses undo, and if you set =5Fdisable=5Floggi=
ng you run
> the same risk, if you have a problem.
> I think for a test database could be acceptable. For example I'm tryin=
g to
> create a 10 000 000 records in my home for testing
> purposes, so this will be greatly welcome.
> I bet there should be a way.

>=20

> =20
> Juan Carlos Reyes Pacheco
> OCP
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 05 2004 - 22:29:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US