rem ----------------------------------------------------------------------- rem Filename: ctxinst.sql rem Purpose: Install Oracle Intermedia Text on a database rem Notes: Tested on 8.1.7. Will not work on versions below 8.1.7. rem Author: Frank Naude, Oracle FAQ rem ----------------------------------------------------------------------- connect SYS AS SYSDBA -- Run drdsys.sql to remove peviously installed CTX components @?/ctx/admin/dr0dsys -- Run drcsys.sql with args USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE @?/ctx/admin/dr0csys.sql ctxsys users temp connect ctxsys/ctxsys -- Run dr0inst.sql, with arg - your CTX library (this one is for HP-UX) @?/ctx/admin/dr0inst /app/oracle/product/8.1.7-32b/ctx/lib/libctxx8.sl -- Run drdefXX.sql to install language, XX = {us, uk, ...} @?/ctx/admin/defaults/drdefus.sql -- Grant users access to use CTX grant CTXAPP to scott;