0 Replies Latest reply: Jul 25, 2011 12:40 PM by Pwjohnso-Oracle RSS

    Context Index fails to create specifying a tablespace

    Pwjohnso-Oracle
      Tablespace for context index exists PMVA_SML_IDX

      SQL> create index NOMNTN_IN ON NOMINATION (nomination_snapshot) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('datastore ctxsys.default_datastore filter ctxsys.null_filter section group ctxsys.auto_section_group tablespace PMVA_SML_IDX')
      /

      fails with the following error messages
      create index NOMNTN_IN
      *
      ERROR at line 1:
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE
      ORA-20000: Oracle Text error:
      DRG-11000: invalid keyword TABLESPACE
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 365.
      Builds the index error free however no tablespace referenced for the index
      SQL> create index NOMNTN_IN ON NOMINATION (nomination_snapshot)INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('datastore ctxsys.default_datastore filter ctxsys.null_filter section group ctxsys.auto_section_group') /
      Index created.
      Any ideas?