| 4:12p |
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 |