******************************************************表插入数据**************************
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';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10129726/viewspace-707999/ ，如需转载，请注明出处，否则将追究法律责任。
