My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

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

**Disclaimer:** This KM article may include the following abbreviations:

MWM - Oracle Utilities Mobile Workforce Management
ORTS/ORS/ERTS - Oracle Real-Time Scheduler
CLOB - Character large object
JVM - Java Virtual Machine
SQL - Standard Query Language
XML - eXtensible Markup Language

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

To view full details, 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 a vibrant support community of peers and Oracle experts.