Large tables created for testing in Oracle

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;

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<l_rows) 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:5000000 old 3:l_rows number:=&1; New 3:l_rows number:=5000000; Pl/sql procedure successfully completed.

Table created.

Insert 5 million data:

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/