User`s guide

10
Oracle Text 10-1
10 Oracle Text
This chapter describes how to install and run Oracle Text and the restrictions of this
option on BS2000/OSD.
10.1 Installing Oracle Text
When you follow the procedures explained in chapter 4 about creating an Oracle
Database 11g Release 2 database the result is not Oracle Text enabled.
If you want to install Oracle Text, then complete the following steps:
1. Start SQL*Plus. To avoid being prompted for many overflow acknowledgements
on the screen set
oflow = no :
/tchng oflow=no
/start-program $ORAC1120.sqlplus
* /nolog
connect / as sysdba
spool catctx.log
@$ORAC1120.ctx.admin.catctx.sql CTXSYS SYSAUX TEMP NOLOCK;
where CTXSYS is the ctxsys user password, SYSAUX is the default tablespace for
ctxsys , TEMP is the temporary tablespace for ctxsys , and LOCK|NOLOCK specifies
whether the
ctxsys user account is locked or not.
2. If you are working with US english texts, then install appropriate
language-specific default preferences:
connect CTXSYS/CTXSYS
@$ORAC1120.ctx.admin.drdefus;
If you are not working with US english texts, then open the drdef*.sql script
according to the preferred language, set the attribute (refer to
Restrictions of
Oracle Text on BS2000/OSD), and run the script.
3. Type exit when finished.
10.2 Starting Oracle Text utilities
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 $ORAC1120.ctxldr
*-user scott/tiger -export -name myindex -file myfile -pk 1