17,377
社区成员
发帖
与我相关
我的任务
分享
SQL>
SQL> create table test(id int, name varchar(10));
Table created
SQL> insert into test values (100,'china');
1 row inserted
SQL> select sum(bytes)/1024/1024, sum(blocks)
2 from user_extents where segment_name ='TEST';
SUM(BYTES)/1024/1024 SUM(BLOCKS)
-------------------- -----------
0.0625 8
SQL> alter table test allocate extent(size 1024M); -- 这句
Table altered
SQL> select sum(bytes)/1024/1024, sum(blocks)
2 from user_extents where segment_name ='TEST';
SUM(BYTES)/1024/1024 SUM(BLOCKS)
-------------------- -----------
1024.0625 131080
SQL> drop table test purge;
Table dropped
SQL>