My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.