This chapter describes how to install and run Oracle Text and the restrictions of this option on BS2000/OSD.
When you follow the procedures explained in chapter 4 about creating an Oracle Database 10g release 2 database the result is not already Oracle Text enabled.
If you want to install Oracle Text, follow these steps:
Start SQL*Plus. To avoid being prompted for many overflow acknowledgements on the screen set
/tchng oflow=no /start-program $ORAC1020.sqlplus * /nolog connect / as sysdba spool catctx.log @$ORAC1020.ctx.admin.catctx.sql CTXSYS SYSAUX TEMP NOLOCK;
ctxsys is the CTXSYS user password,
SYSAUX is the default tablespace for
TEMP is the temporary tablespace for
LOCK|NOLOCK specifies whether the
ctxsys user account will be locked or not.
If you are working with US english texts, install appropriate language-specific default preferences:
connect CTXSYS/CTXSYS @$ORAC1020.ctx.admin.drdefus;
If you are not working with US english texts, open the
drdef*.sql script according to the preferred language, set the attribute (refer to Restrictions in the following section), and run the script.
exit when finished.
The Oracle Text loader utility,
ctxldr, is available within the Oracle Text option. For more information about its functions and parameters, refer to Oracle Text Reference.
The following is an example of how to start the Oracle Text utility:
/start-program $ORAC1020.ctxldr (when prompted with * enter, for example:) *-user scott/tiger -export -name myindex -file myfile -pk 1
Due to ASCII-EBCDIC and other dependencies following restrictions are inherent:
No index themes, that is
NO') must be set
No INSO filters, which are licensed on special platforms only
ctxkbtc, which are knowledge base utility)
No fuzzy operators but corresponding attributes should not be set
URL_DATASTORE objects are not supported
FILE_DATASTORE objects may reside on native BS2000 DMS as PAM files or on the POSIX file system.