Heres my script if you could look at it.... BEGIN EXECUTE IMMEDIATE 'CTXSYS.CREATE_INDEX_SET ''IDXSET_RECKEYWDDATEDESC'')'; COMMIT; Ive also tried CTXSYS.CTX_DLL.Create_Index_set and CTX_DLL.Create_Index_set inside the execute but cant get it to run. I can create the index alright but not the index -set. I,m using Toad again. I,ve also tried using quotes around the statement and without them. Any ideas Heres how I create the index Begin Execute immediate ('CREATE INDEX IDX_REC_KEYWD_DATE_DESC ON MyTable (Keywords) INDEXTYPE IS CTXSYS.CTXCAT'); End;
From novice to tech pro — start learning today.