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 ../com.ibm.help.install.ompostinstallation.doc/c_EnablingTheOracleDatabaseTextSearchFeature-Overview.html ../com.ibm.help.upgrade.post.cpq.doc/t_PostmigrationTasks-EnablingTextSearchFeatureOnOracleDatabase.html for information about text search features on the Oracle database.