Database Administration (MOSC)

MOSC Banner

truncate table IDL_UB1$

edited Feb 15, 2016 10:28AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hello,

I would ask you, does it safe to truncate table IDL_UB1$ ?

I use Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

I use following query to check segment size for tablespace "SYSTEM"

select owner,segment_name,segment_type

,bytes/(1024*1024) size_m

from dba_segments

where tablespace_name = 'SYSTEM'

and    bytes/(1024*1024) > 1

order by size_m desc

Result below:

SYSIDL_UB1$TABLE14986
SYSI_SOURCE1INDEX9163
SYSSOURCE$TABLE6649
SYSIDL_UB2$TABLE2797
SYSI_WARNING_SETTINGSINDEX2784
SYSARGUMENT$TABLE1232
SYSI_ARGUMENT1INDEX1090
SYSWARNING_SETTINGS$TABLE882
SYSIDL_CHAR$TABLE695
SYSI_ARGUMENT2INDEX554
SYSC_OBJ#

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center