To use CUBE, you need very high speed CPU and a lot of TEMP tablespace.

You can try this method:

execute dbms_random.seed(630522626) ;

create table random_table
tablespace large_data
as
select
substr(dbms_random.string('a',30),1,30) id1,
substr(dbms_random.string('a',30),1,30) id2,
substr(dbms_random.string('a',30),1,30) id3,
substr(dbms_random.string('a',30),1,30) id4,
substr(dbms_random.string('a',30),1,30) id5,
substr(dbms_random.string('a',30),1,30) id6,
substr(dbms_random.string('a',30),1,30) id7,
substr(dbms_random.string('a',30),1,30) id8,
substr(dbms_random.string('a',30),1,30) id9,
substr(dbms_random.string('a',30),1,30) id10
from dba_objects where rownum < 32000
;

Once the table is created, you can use insert into the random_table by selecting rows from the same table. Or you can use dbms_random.string within the select in the insert statement.

Tamil