Database Software

Let's describe it as - " I always want to much " (but I guess there is no solution / only a workaround...) ???

SQL> drop  index WIKI_XMLINDEX01 force;

Index dropped.

CREATE INDEX WIKI_XMLINDEX01 ON "WIKI_STAGE"(object_value) 
  INDEXTYPE IS XDB.XMLINDEX
  PARAMETERS ('PATHS (INCLUDE (/page/revision/comment)
                      NAMESPACE MAPPING (xmlns="http://www.mediawiki.org/xml/export-0.3/"))
                      PATH TABLE      path_table_01
                          ( PCTFREE 5 PCTUSED 90 INITRANS 5
                            STORAGE (INITIAL 1k NEXT 2k MINEXTENTS 3 BUFFER_POOL KEEP)
                                     NOLOGGING ENABLE ROW MOVEMENT PARALLEL 4
                                    )
                            TABLESPACE mediawiki_xmlindex
                          )
                      PATH ID INDEX   pathid_xmlindex_01
                          (PCTFREE 5 PCTUSED 90 INITRANS 5
                            STORAGE (INITIAL 1k NEXT 2k MINEXTENTS 3 BUFFER_POOL KEEP)
                                     NOLOGGING PARALLEL 4
                                    )
                            TABLESPACE mediawiki_xmlindex
                           )
                       ORDER KEY INDEX orderkey_xmlindex_01
                          (PCTFREE 5 PCTUSED 90 INITRANS 5
                            STORAGE (INITIAL 1k NEXT 2k MINEXTENTS 3 BUFFER_POOL KEEP)
                                     NOLOGGING PARALLEL 4
                                    )
                            TABLESPACE mediawiki_xmlindex
                           )
              '); 
CREATE INDEX WIKI_XMLINDEX01 ON "WIKI_STAGE"(object_value)
*
ERROR at line 1:
ORA-29896: Length of PARAMETER string longer than 1000 characters

Solved it by wanting "less" (but I guess there is still an PARAMETER issue here).

SQL> drop  index WIKI_XMLINDEX01 force;

Index dropped.

CREATE INDEX WIKI_XMLINDEX01 ON "WIKI_STAGE"(object_value) 
INDEXTYPE IS XDB.XMLINDEX
PARAMETERS ('PATHS (INCLUDE (/page/revision/comment)
                    NAMESPACE MAPPING (xmlns="http://www.mediawiki.org/xml/export-0.3/"))
                    PATH TABLE      path_table_01
                        (NOLOGGING ENABLE ROW MOVEMENT PARALLEL 4 TABLESPACE mediawiki_xmlindex )
                    PATH ID INDEX   pathid_xmlindex_01
                        (NOLOGGING PARALLEL 4 TABLESPACE mediawiki_xmlindex )
                    ORDER KEY INDEX orderkey_xmlindex_01
                        (NOLOGGING PARALLEL 4 TABLESPACE mediawiki_xmlindex )
            '); 

Message was edited by:
Marco Gralike