Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with DBMS_METADATA.GET_DDL and subpartitions

595637Mar 22 2012 — edited Mar 27 2012
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2012
Added on Mar 22 2012
6 comments
1,024 views