How To Clear LOB Segment For Table F1_TSPACE_ENTRY Occupying 7 GB In Database (Doc ID 1931006.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 and later
Oracle Real-Time Scheduler - Version 2.1.0 and later
Oracle Utilities Framework - Version 4.1.0 and later
Information in this document applies to any platform.

Symptoms

In one of our MWM/ORS environments, we have noticed that one of the log segments corresponding to the table F1_TSPACE_ENTRY is occupying 7 GB of space. As a result, our application tablespace has been completely filled up leading to errors in the application including, 'ORA-01654: unable to extend index CISADM.XT241P0 by 128 in tablespace CISTS_01'. Can you please advise on how this space can be reclaimed/freed by purging/deleting/truncating and why it has filled up to this extent?

Following are the details:

 

Cause

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