truncate table IDL_UB1$
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:
SYS | IDL_UB1$ | TABLE | 14986 |
SYS | I_SOURCE1 | INDEX | 9163 |
SYS | SOURCE$ | TABLE | 6649 |
SYS | IDL_UB2$ | TABLE | 2797 |
SYS | I_WARNING_SETTINGS | INDEX | 2784 |
SYS | ARGUMENT$ | TABLE | 1232 |
SYS | I_ARGUMENT1 | INDEX | 1090 |
SYS | WARNING_SETTINGS$ | TABLE | 882 |
SYS | IDL_CHAR$ | TABLE | 695 |
SYS | I_ARGUMENT2 | INDEX | 554 |
SYS | C_OBJ# |