Today in Oracle11g environment manufacturing data encountered ORA-30009: CONNECTBY operation memory is insufficient, 10g began to support XML, changed to xmltable can be.
Today in the Oracle 11G environment manufacturing data encountered ORA-30009: connect by Operation memory is insufficient, 10g began to support XML, changed to xmltable can be.
Today in the Oracle 11G environment manufacturing data encountered ORA-30009: connect by Operation memory is insufficient, 10g began to support XML, changed to xmltable can be.
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 p_2014_7 values less than (to_date ('2017-08-01 ', 'yyyy-mm-dd ')),
Partition p_2014_8 values less than (to_date ('2017-09-01 ', 'yyyy-mm-dd ')),
Partition p_2014_9 values less than (to_date ('2017-10-01 ', 'yyyy-mm-dd ')),
Partition p_2014_10 values less than (to_date ('2017-11-01 ', 'yyyy-mm-dd ')),
Partition p_2014_11 values less than (to_date ('2017-12-01 ', 'yyyy-mm-dd ')),
Partition p_2014_12 values less than (to_date ('2017-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 (0,120 )),
'J ')
From dual
Connect by level <= 2000000;
Insert/* + append */into t_range select rownum,
*
Row 3 has an error:
ORA-30009: connect by memory insufficient
Used time: 00: 00: 10.28
SQL> rollback;
Rollback completed.
SQL> insert/* + append */into t_range select rownum,
To_date (to_char (sysdate-120, 'J') +
Trunc (dbms_random.value (0,120 )),
'J ')
From xmltable ('1 to 2000000 ');
You have created 2000000 rows.
Used time: 00: 00: 28.76
SQL> commit;
Migration from 32-bit to 64-bit for a single Oracle instance
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
Oracle Import and Export expdp IMPDP details
Solution to Oracle 10g expdp export error ORA-4031