Administration Guide for Oracle Billing Insight > Database Partitioning > Process of Setting Up New Group Database Partitions >

Creating a New Partition Group

For each new database partition you want to create in Oracle Billing Insight, you must create a new group.

This task is a step in Process of Setting Up New Group Database Partitions.

To create a new partition group

• Using a SQL tool such as Toad, Oracle SQL Developer, or SQL*Plus, execute the OLAP database function fn_Create_Group located in the package pkg_olap_group_mgmt. Specify the following input parameters with the function:
  • P_GROUP_KEY. A value for the group key you are creating.
  • P_TABLESPACE. The tablespace to be associated with any partitions and subpartitions going forward.
  • P_START_DATE. The start date of the group, which determines the start period for partitions and subpartitions that are period-key driven.
  • P_DESC. Description for the group being created. This parameter is optional.

    The function generates one output parameter indicating whether the process was successful. A value of 0 (zero) indicates success. Any other value is an error. For errors, see the OLAP log table, EDX_RPT_ETL_LOG and the OLTP log table, EDX_OLTP_LOADER_LOG.