How To Clear LOB Segment For Table F1_TSPACE_ENTRY Occupying 7 GB In Database
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.
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:
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