Anybody know if there is a way in Oracle to change the on commit of a temporary table from preserve rows to delete rows? Alter table doesn't seem to like it if I try alter table X on commit delete rows.
That leaves me with drop table X; create global temporary table X ... on commit delete rows; create index ..... ;
cheers.
That leaves me with drop table X; create global temporary table X ... on commit delete rows; create index ..... ;
cheers.
