Can the Service Contracts OKS_LEVEL_ELEMENTS Data Be Purged?

(Doc ID 1099040.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Service Contracts - Version 11.5.9 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 01-Dec-2014***

Goal

The OKS_LEVEL_ELEMENTS table is occupying a lot of space. Can the data in this table be purged?

The following OKS objects occupy a lot of space.


Tablespace_Name  Segment_Name
---------------  --------------------------
APPS_TS_TX_DATA  OKS_LEVEL_ELEMENTS
APPS_TS_TX_DATA  OKS_SUBSCR_ELEMENTS
APPS_TS_TX_IDX   OKS_LEVEL_ELEMENTS_U1
APPS_TS_TX_IDX   OKS_LEVEL_ELEMENTS_N1
APPS_TS_TX_IDX   OKS_LEVEL_ELEMENTS_N2
APPS_TS_TX_IDX   OKS_LEVEL_ELEMENTS_N4
APPS_TS_TX_IDX   OKS_SUBSCR_ELEMENTS_ABP_N1
APPS_TS_TX_IDX   OKS_SUBSCR_ELEMENTS_U1
APPS_TS_TX_IDX   OKS_LEVEL_ELEMENTS_N3
APPS_TS_TX_IDX   OKS_LEVEL_ELEMENTS_N5
APPS_TS_TX_DATA  OKS_SUBSCR_ELEMENTS_ABP_N2

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms