Shulou(Shulou.com)06/01 Report--

ORA-30009: insufficient memory for CONNECT BY operation. 10g supports XML, which can be changed to xmltable.

SQL > drop table t_range purge

SQL > create table t_range (id number not null PRIMARY KEY, test_date date) partition by range (test_date)

(

Partition packs 2014 July 7 values less than (to_date ('2014-08-01,' yyyy-mm-dd'))

Partition packs 2014-08 values less than (to_date ('2014-09-01,' yyyy-mm-dd'))

Partition packs 2014 September 9 values less than (to_date ('2014-10-01 values less than,' yyyy-mm-dd'))

Partition packs 2014 / 10 values less than (to_date ('2014-11-01 /' yyyy-mm-dd'))

Partition packs 2014 11 values less than (to_date ('2014-12-01,' yyyy-mm-dd'))

Partition packs 2014-12 values less than (to_date ('2015-01-01-01-01,' yyyy-mm-dd'))

Partition p_max values less than (MAXVALUE)

) nologging

SQL > insert / + append / into t_range select rownum

To_date (to_char (sysdate-120,' J') +

Trunc (dbms_random.value (0120))

'J')

From dual

Connect by level rollback

The fallback is complete.

SQL > insert / + append / into t_range select rownum

To_date (to_char (sysdate-120,' J') +

Trunc (dbms_random.value (0120))

'J')

From xmltable ('1 to 2000000')

2000000 rows were created.

Time spent: 00: 00: 28.76

SQL > commit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.