5.1.7.5 Index DDLs [Data Definition Language]

Starter kit bundles index DDL’s from tables that have indexes as part of Starter Kit Generation. These scripts can be executed manually by following the below steps.

Steps to execute:

• Copy the manifest_fsapps_Table_Index_create.sql available in the IndexDDL folder to any user specified folder.
• Logan to database schema user where Starter Kit objects are installed.

  Example: sqlplus <schema_username>/<schema_password> @<db_service_name>

• For logging enable spooling of execution logs:

  Example: spool <absolute_folderpath_for_logging>/IndexDDL.log

• Execute the manifest_fsapps_Table_Index_create.sql from the sqlplus prompt. Example: @<absolute_path_of_ manifest_fsapps_Table_Index_create.sql.sql>