Creating XMLIndex on a Table Converted from Interval Partition to Range Fails with ORA-30982 (Doc ID 2025828.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

In Oracle Database 11.2.0.4, the creation of an xmlindex with statement

SQL> CREATE INDEX DSL_TEST.IDX_CE_TESTCASE ON DSL_TEST.T_CE_ARCHIVE_TESTCASE (XML_DOCUMENT)
 2 INDEXTYPE IS XDB.XMLIndex
 3 LOCAL PARALLEL
 4 PARAMETERS (
 5 'XMLTable T_CE_TESTCASE_PATH_TABLE
 6 ( TABLESPACE DSL_DATA )
 7 ''/controlEvent/eventParameters''
 8 COLUMNS ASSET_CLASS VARCHAR2(30) PATH ''assetClass'',
 9 SOURCE_SYSTEM_TYPE VARCHAR2(30) PATH ''eventType/sourceSystemType'',
10 PRODUCT_TYPE VARCHAR2(30) PATH ''parameters/map/entry[@key="productType"]''
11 ');

raises the error
ORA-30982: Invalid option for a partition of an XML Index

Steps to reproduce
---------------------
1) create an empty table - interval partitioned
2) inserted 1000 rows from each partition of the original table
3) converted the table to range partitioning with this command
alter table DSL_TEST.T_CE_ARCHIVE_TESTCASE set interval ();
4) attempted to create the xml index

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms