Stale Option Not Documented Correctly in XDB Developers Guide for XMLINDEX (Doc ID 455491.1)

Last updated on SEPTEMBER 05, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.
Checked for relevance on 06-Sep-2010

Symptoms

Binary XML based on binary registered XSD as described

Documentation describes STALE as

STALE is optional. A value of TRUE means that query results might be stale; a value of FALSE means that query results are always up-to-date. The default value, and the only permitted explicitly specified value, is as follows.

For ALWAYS, STALE is TRUE.

For any other ASYNC option besides ALWAYS, STALE is FALSE.


Apparently in the 11.1.0.6.0 prod env. ONLY the following two options are allowed, so this is CONTRARY to the documentation:

- For ALWAYS, STALE is FALSE.
- For any other ASYNC option besides ALWAYS, STALE is TRUE.

Other option gives error during creation...

SQL> CREATE INDEX XMLBIN_IX on XMLBIN (object_value)
2 INDEXTYPE IS XDB.XMLIndex
3 PARAMETERS ('PATHS (INCLUDE (/ROOT/ID
4 /ROOT/INFO/INFO_ID
5 )
6 NAMESPACE MAPPING (xmlns="http://localhost/public/xsd/myapp.xsd")
7 )
8 PATH TABLE xmlbin_path_table
9 PATH ID INDEX xmlbin_pathid_ix
10 ORDER KEY INDEX xmlbin_orderkey_ix
11 ASYNC (SYNC ALWAYS) STALE (TRUE)
12 ')
13 PARALLEL 4;
CREATE INDEX XMLBIN_IX on XMLBIN (object_value)
*
ERROR at line 1:
ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine
ORA-30969: invalid syntax for PARAMETERS

SQL> CREATE INDEX XMLBIN_IX on XMLBIN (object_value)
2 INDEXTYPE IS XDB.XMLIndex
3 PARAMETERS ('PATHS (INCLUDE (/ROOT/ID
4 /ROOT/INFO/INFO_ID
5 )
6 NAMESPACE MAPPING (xmlns="http://localhost/public/xsd/myapp.xsd")
7 )
8 PATH TABLE xmlbin_path_table
9 PATH ID INDEX xmlbin_pathid_ix
10 ORDER KEY INDEX xmlbin_orderkey_ix
11 ASYNC (SYNC ALWAYS) STALE (FALSE)
12 ')
13 PARALLEL 4;

Index Created.

SQL> drop index xmlbin_ix force;

Index Dropped.

SQL> CREATE INDEX XMLBIN_IX on XMLBIN (object_value)
2 INDEXTYPE IS XDB.XMLIndex
3 PARAMETERS ('PATHS (INCLUDE (/ROOT/ID
4 /ROOT/INFO/INFO_ID
5 )
6 NAMESPACE MAPPING (xmlns="http://localhost/public/xsd/myapp.xsd")
7 )
8 PATH TABLE xmlbin_path_table
9 PATH ID INDEX xmlbin_pathid_ix
10 ORDER KEY INDEX xmlbin_orderkey_ix
11 ASYNC (SYNC MANUAL) STALE (TRUE)
12 ')
13 PARALLEL 4;

Index created.

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