Problem with DBMS_METADATA.GET_DDL and subpartitions
595637Mar 22 2012 — edited Mar 27 2012I have problems with DBMS_METADATA.GET_DDL in a 11gR2 (11.2.0.3) database on Linux. The following example shows the problem:
CREATE TABLE Test_tbl
(
C1 NUMBER(14),
C2 NUMBER(14),
C3 NUMBER(14)
)
PARTITION BY RANGE (C1)
SUBPARTITION BY LIST (C2)
(
PARTITION Part1 VALUES LESS THAN (1000)
, PARTITION Part2 VALUES LESS THAN (2000)
);
CREATE INDEX Test_idx ON Test_tbl (C3) LOCAL;
When I execute
SELECT DBMS_METADATA.GET_DDL('INDEX','TEST_IDX') from dual;
on a 10g database (10.2.0.2.0) on Solaris Sparc and on a 11.1.0.7 on Windows, it gives the correct DDL statement within some seconds.
On the 11.2.0.3 database (Linux) it hangs forever.
SQL> SELECT DBMS_METADATA.GET_DDL('INDEX','TEST_IDX') from dual;
^CERROR:
ORA-01013: user requested cancel of current operation
This behavior only seems to occur in combination with local indexes and subpartitions.
Anyone any idea?
Thx, Carsten