Setting up scripts when using locally managed tablespaces or other utility to size database

About this task

To configure your Oracle database for your production environment, you must set up and run a series of scripts to create the tables, indexes, sequences, and so forth for your schema.

These script files reside in the <INSTALL_DIR>/database/oracle/scripts/ directory. The yfs_master_db_script.sql script is the master script that calls all view scripts required for creating views. Table, index, and sequence creation DDLs are created during installation. These reside in the <INSTALL_DIR>/repository/scripts directory.

You must run these scripts only if you are manually creating the views after installation (REINIT_DB=no). In the normal installation mode (REINIT_DB=yes), the views will be applied automatically.

Refer to Enabling the Oracle Database test search feature - overview for information about text search features on the Oracle database.