******************************************************表插入数据**************************

create table test_table3(

u_id char(10),

u_name varchar2(20),

u_age int

) tablespace large;

***********************

create table tabA (

id  char(10),

name varchar2(20),

code  int,

aaa   varchar2(20),

bbb  varchar2(20),

ccc  varchar2(20),

ddd varchar2(20),

eee varchar2(20),

fff varchar2(20),

ggg varchar2(20),

loop  int)

tablespace test;

************

declare

n_loop int;

begin

n_loop := 0;

loop

insert into tabA values('123456789','huaweitesttesttest','87837847','abcdefgsefgsvds','abcdefgsdfgsedssdev',

'abcdefgsdfgdvdssdev','abcdefgsdfgsvdssddv','abcdefgsdfgsvdsddev','abcdefgbdfgsvdssdev','abcdefgsdfgsvdssdfv',n_loop);

commit;

n_loop := n_loop + 1;

exit when n_loop>10000000;

End loop;

end;

查看表的大小select segment_name,bytes/1024/1024 from user_segments/dba_segments  where segment_name='TEST_TABLE1';