Administration Guide for Oracle Billing Insight > Database Partitioning >

Removing an Empty Partition Group Key

If you experience an issue while creating a new partition group, then you can remove that empty group key and any partitions that have been created for that group.

To remove an empty partition group key

• Using a SQL tool such as Toad, Oracle SQL Developer, or SQL*Plus, execute the pr_cleanup_partn function, located in the pkg_olap_group_mgmt package. For the input parameter p_group_key, specify the group key associated with the partition you want to drop.

  If the function does not detect data in the partition, then it drops all the partitions associated with the specified group key. If the function detects data in the partition, then the function fails and logs the reason. The function generates one output parameter, p_status, indicating whether the process was successful. A value of zero indicates that the process was successful. 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.