Saturday, August 2, 2008

Fill up a tablespace

Very Simple PL/SQL loop to fill up a tablespace.


create table fill_table (x int, y char(2000));


begin
loop
insert into fill_table values (1,'x');
commit;
end loop;
end;
/

And just wait . . .


********************************************
rdbms ver : 9.2 - 11g
********************************************
keywords: fill up tablespace
********************************************

No comments: