resumable space allocation
HR:SQL> create table t062ad08_a ( a number ) storage ( initial 16M );
Table created.
SYS:
create or replace trigger trg1
after suspend
on database
declare
v_size number;
v_file_name varchar2(100);
pragma AUTONOMOUS_TRANSACTION;
begin
selectBYTES into v_size from dba_data_files wheretablespace_name='TBS1' ;
selectfile_name into v_file_name from dba_data_files wheretablespace_name='TBS1' ;
execute immediate 'alter database datafile '||v_file_name||' resize '||to_char(v_size+10485760);
commit;
end;
/
页:
[1]