Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate 100mb worth of table data using for loop

resistanceIsFruitfulMar 29 2012 — edited Mar 29 2012
DB version:11.2

How can I create rougly 100mb of test data in a table using minum number of records.
If I use the below FOR loop. It takes 100,000 records to populate just 2mb.
SQL> create table a2 (mynum1 number, mynum2 number);

Table created.

begin
for i in 1..100000 loop
    insert into a2 values(i,i*2);
end loop;
end;


select segment_name, bytes/1024/1024 MB from dba_segments where segment_name = 'A2' AND owner='SCOTT'


SEGMENT  BYTES/1024/1024
-------- ---------------
A2                     2
This post has been answered by Lukasz Mastalerz on Mar 29 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2012
Added on Mar 29 2012
3 comments
620 views