1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| create table tmp (vc varchar2(4000), vc2 varchar2(4000), vc3 varchar2(4000) not null,n number not null) pctfree 0;
create table tmp2 (n number not null, vc varchar2(4000),vc2 varchar2(4000), vc3 varchar2(4000)) pctfree 0;
create table tmp3 (n1 number,n2 number,n3 number,n number not null) pctfree 0;
create table tmp4 (n number not null,n1 number,n2 number,n3 number) pctfree 0;
insert into tmp (vc,vc2,vc3,n) select 'a','b','c',level from dual connect by level<1e4;
insert into tmp select * from tmp;
insert into tmp2 (vc,vc2,vc3,n) select 'a','b','c',level from dual connect by level<1e4;
insert into tmp2 select * from tmp2;
insert into tmp3 (n) select level from dual connect by level<1e4;
insert into tmp3 select * from tmp3;
insert into tmp4 (n) select level from dual connect by level<1e4;
insert into tmp4 select * from tmp4;
select segment_name, segment_type, bytes, blocks, extents from user_segments order by blocks; |
Partager