Nice demo (I was far too lazy to do so....) You get redo because you need to be able to issue: "rollback" on a GTT =20 I would indeed be to have a "I can't rollback" option on GTT's Cheers Connor On 5/19/05, Tim Gorman <tim@xxxxxxxxx> wrote: > Connor, >=20 > I'm a little hard-pressed to imagine why any redo at all should be genera= ted > for GTT, but it can't be too hard to test. If I wasn't so lazy I'd also > fire up Log Miner and look at what is being generated... >=20 --=20 Connor McDonald =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l