Oracle Database Discussions

Hi,

Good Evening!!!

Am testing the In-Memory concept in 12c database.

I have installed 12c database 12.1.0.2 in my laptop which is supported version for In-Memory.

After installation i have enabled the In-memory option.

For testing i have to create the tables with huge amount of values.

I got some queries from online, while running this below query am getting error,

SQL> insert into orders

  2    select initcap(dbms_random.string('1', dbms_random.value(4, 6))),

  3           round(dbms_random.value(1, 100), 2),

  4           to_date('01.01.2013', 'dd.mm.yyyy') + dbms_random.value(-100, 100)

,

  5           trunc(dbms_random.value(1,15000))

  6      from (select level from dual connect by level <= 11000000);

insert into orders

            *

ERROR at line 1:

ORA-30009: Not enough memory for CONNECT BY operation

I have changed the pga_aggregate_value to 200 then 400 then 500

But still issue not resolved.

Kindly suggest me to solve this issue.

Regards

Kumar