BEGIN
ctx_ddl.create_preference('mywordlist',  'BASIC_WORDLIST'); 
ctx_ddl.set_attribute('mywordlist', 'PREFIX_INDEX', 'TRUE');
ctx_ddl.set_attribute('mywordlist', 'PREFIX_MIN_LENGTH',  '1');
ctx_ddl.set_attribute('mywordlist', 'SUBSTRING_INDEX',  'TRUE');
END;
/

CREATE INDEX LOCAL_SURNAME_CTX ON PUBAUTHOR(SURNAME) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');

CREATE INDEX LOCAL_SUFFIX_CTX ON PUBAUTHOR(SUFFIX) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');

CREATE INDEX LOCAL_GIVENNAMES_CTX ON PUBAUTHOR(GIVENNAMES) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');

CREATE INDEX LOCAL_PUBVALUES_CTX ON PUBPROP(VALUE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');

CREATE INDEX LOCAL_PUBTITLE_CTX ON PUB(TITLE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');

CREATE INDEX LOCAL_PUBSERIES_CTX ON PUB(SERIES_NAME) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');

CREATE INDEX LOCAL_SURNAME_IDX ON PUBAUTHOR(UPPER(SURNAME));

CREATE INDEX LOCAL_SUFFIX_IDX ON PUBAUTHOR(UPPER(SUFFIX));

CREATE INDEX LOCAL_GIVENNAMES_IDX ON PUBAUTHOR(UPPER(GIVENNAMES));

CREATE INDEX LOCAL_PUBSERIES_IDX ON PUB(UPPER(SERIES_NAME));