RE: Please a parameter to disable undo, like _disable_logging
- From: John Clarke <jclarke@xxxxxxxxxxxxxxx>
- To: jreyes@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 5 Oct 2004 23:33:36 -0400
/*+ 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
----- Original Message -----
From: Juan Carlos Reyes Pacheco <jreyes@xxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tue, 5 Oct 2004 20:23:01 -0400
Subject: RE: Please a parameter to disable undo, like =5Fdisable=5Floggi=
ng
> 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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » Re: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » Re: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » Re: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » Re: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » Re: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » Re: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging
- » RE: Please a parameter to disable undo, like _disable_logging