修改参数
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
测试
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;
黑人问号???
查看表大小
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;