resumable space allocation

botang

HR:

1. SQL> create table t062ad08_a ( a number ) storage ( initial 16M );      
   
2. 
   
3. Table created.
   

复制代码

SYS:

1. create or replace trigger trg1
   
2. after suspend
   
3. on database
   
4. declare
   
5.   v_size number;
   
6.   v_file_name varchar2(100);
   
7.   pragma AUTONOMOUS_TRANSACTION;
   
8. begin
   
9.   select  BYTES into v_size from dba_data_files where  tablespace_name='TBS1' ;
   
10.   select  file_name into v_file_name from dba_data_files where  tablespace_name='TBS1' ;
    
11.   execute immediate 'alter database datafile '||v_file_name||' resize '||to_char(v_size+10485760);
    
12.   commit;
    
13. end;
    
14. /
    

复制代码