Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Huge undotbs during insert
>
> nologging is not a hint as far as I can recall...
>
> However, with the append hint, the undo generation should be small -
> have you got indexes on the table ? best to set these to unusable before
> adding lots of rows
>
> hth
> connor
Thanks Connor,
I thought NOLOGGING was a hint in 9i, not sure ( is there somewhere a list
of all hints ? )
Yes there is a lot of indexes,
I would like to put them in unusable mode but
I didn't see this parmeter in 9i only in 10g ????
Received on Sun May 29 2005 - 03:36:59 CDT