Oracle creates a large table for testing

Personal experiments sometimes use large tables, where you can share the dba_objects to create a test large table:

First set up the test table

Sys@orcl>create table Test nologging as Select RowNum id,a.* from Dba_objects a where 1=2;

Table created.

Insert 5 million data:

Sys@orcl>declare

L_CNT number;

L_rows number:=&1;

Begin

Insert/*+ Append */into Test select rownum,a.* from Dba_objects A;

L_cnt:=sql%rowcount;

Commit

while (l_cnt

Loop

Insert/*+ Append */Into Test select rownum+l_cnt,

Owner,object_name,subobject_name,

OBJECT_ID,DATA_OBJECT_ID,

Object_type,created,last_ddl_time,

Timestamp,status,temporary,

Generated,secondary

From sales

where rownum<=l_rows-l_cnt;

L_cnt:=l_cnt+sql%rowcount;

Commit

End Loop;

End 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20-21

22/

Enter value for 1:5 million

Old 3:l_rows number:=&1;

New 3:l_rows number:=5000000;

Pl/sql procedure successfully completed.