{16 追加}再開可能領域割当て機能の有効化

 

https://docs.oracle.com/cd/F19136_01/admin/managing-space-for-schema-objects.html#GUID-E464327C-6434-4CFC-A6F5-BC4424353ACE

sqlplus test/test@pdb11

ALTER SESSION ENABLE RESUMABLE TIMEOUT 3600;

select * from dba_tablespaces;
select * from dba_data_files;

CREATE TABLESPACE tbs55
   DATAFILE '/oradata/orcl/pdb11/tbs55.dbf' SIZE 10M  autoextend off;

create table tab55 (col1 varchar2(100) ) tablespace tbs55;

insert into tab55 values('11111111111111111111111');
commit;

insert into tab55 select * from tab55;
commit;

alter database datafile '/oradata/orcl/pdb11/tbs55.dbf' autoextend on;

 

select * from DBA_RESUMABLE;