How To Clear LOB Segment For Table F1_TSPACE_ENTRY Occupying 7 GB In Database
(Doc ID 1931006.1)
Last updated on JULY 29, 2020
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.
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!