Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
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;
|Two Oracle Queries - Different Results - Why?||9||50|
|Oracle - running a packate routine(function) - Testing in a cursor and comparing old and new||7||35|
|Case Statement in SQL Delminted Query||9||48|
|Oracle SQL Select Statement||19||40|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!