temporary table duration

[aspdba]

imh

create global temporary table a1
( a2 number);-->session specific tables

create global temporary table a1
( a2 number) on commit preserver/delete rows; -->transaction specific

and the duration as NULL ones..are the permenant tables.