Dropping the Eligible Table Partitions

Once you identify the table partitions which are eligible for dropping, you can drop the eligible table partitions. However, we recommend you to take a backup of the eligible table partitions before dropping them.

Procedure

To drop an eligible table partition:

  1. Connect to the ORMB database using a utility named SQL*Plus and the administrator's (for example, CISADM) credentials.
  2. Execute the following command: 
    ALTER TABLE <TABLE_NAME> DROP PARTITION <PARTITION_NAME>

    For example, 

    ALTER TABLE CI_BSEG DROP PARTITION SYS_P0264
    Note:

    When a partition from the parent table is dropped, the corresponding partitions from the child tables are automatically dropped due to reference partitioning. For example, CI_​ADJ is a parent table and CI_​ADJ_​APREQ, CI_​ADJ_​CALC_​LN, CI_​ADJ_​CHAR, and CI_​ADJ_​CL_​CHAR are its child tables. When you drop a partition from the CI_​ADJ table, all corresponding partitions from all child tables are dropped, automatically.

    While dropping the table partitions for the Billing module, ensure that all eligible table partitions on the CI_​BILL, CI_​BSEG, CI_​BILL_​CHG, and CI_​ADJ tables are dropped together for a particular high value date.

    This activity of dropping eligible table partitions should be taken up during off peak hours to avoid performance issues.