kā iztīrīt lielu temporālu tabulu, kurā dati ir uz sesiju,
neaiztiekot temporālās tabulas, kurās dati ir tikai uz transakciju?

test>


create global temporary table gt1 (id number(12)) on commit delete rows;

create global temporary table gt2 (id number(12)) on commit preserve rows;

insert into gt1 values(1);

insert into gt2 values(2);

declare pragma autonomous_transaction;
begin
execute immediate 'truncate table gt2';
end;
/


select * from gt1;
ID
---------
1

select * from gt2;
> no rows