Skip Headers
Oracle® Database Installation and Administration Guide
11g Release 2 (11.2) for Fujitsu BS2000/OSD

Part Number E27508-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

10.3 Restrictions of Oracle Text on BS2000/OSD

Due to ASCII-EBCDIC and other dependencies, the following restrictions are inherent: