resumable_timeout

修改参数

show parameter resumable_timeout
alter session enable resumable; 
alter system set resumable_timeout=7200;
show parameter resumable_timeout

show parameter deferred_segment_creation
alter system set deferred_segment_creation=false;
show parameter deferred_segment_creation

测试

resumable_timeout参数说明

create user u1 identified by quota default tablespace sales temporary tablespace temp quota 1M on sales;

grant create session, create table, connect, select any table to u1;

select tablespace_name,username,max_bytes/1024/1024 MB from DBA_TS_QUOTAS where username='U1';

conn u1/quota;
create table t1 as select * from dba_objects;

黑人问号？？？

oracle数据库用户对表空间配额

查看表大小

SELECT
	owner,
	segment_name,
	round( sum( bytes / 1024 / 1024 ), 2 ) MB 
FROM
	dba_segments 
WHERE
	owner = 'U2' 
	AND segment_type = 'TABLE' -- 如果是分区表, 则 segment_type = 'TABLE PARTITION'
GROUP BY
	owner,
	segment_name 
ORDER BY
	3 DESC;

查看Oracle库表占用大小