william milbratz wrote:
>>Which type of GTT did you build? It makes a big difference.
>
>
> If you mean by type the "on commit" clause, I've specified "on commit
> delete rows", i.e. the data lasts only for the transaction.
>
> Would you care to elaborate on "makes a big difference" ?
>
> thanks,
>
> bill m
There is a difference in the overhead and undo between the two different
types. For example you can use DBMS_FLASHBACK on one but not on the
other because nothing is saved.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat Feb 07 2004 - 01:00:16 CST
