5.1.7.6 Partition DDLs [Data Definition Language]

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

Steps to execute:

• Copy the manifest_fsapps_Partition_Table_create.sql available in the partitionDDL folder to any user specified folder.
• Log into 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>/PartitionDDL.log

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