How can i reduce size of system datafile ?
Hi,
How can i reduce size of system datafile ?
alter database datafile 1 resize xxM;
ORA-03297:
The problem is with the following objects :
select segment_name, segment_type, block_id*8192/(1024*1024) from dba_extents where tablespace_name='SYSTEM' order by 3;
SEGMENT_NAME SEGMENT_TYPE BLOCK_ID*8192/(1024*1024)
------------------------------ ------------------ -------------------------
.
.
.
.
C_OBJ#_INTCOL# CLUSTER 746
C_OBJ#_INTCOL# CLUSTER 747
C_OBJ#_INTCOL# CLUSTER 4353
C_FILE#_BLOCK# CLUSTER 4354
C_OBJ#_INTCOL# CLUSTER 4355
C_OBJ#_INTCOL# CLUSTER 5061
C_OBJ#_INTCOL# CLUSTER 8449
C_OBJ#_INTCOL# CLUSTER 8450
C_OBJ#_INTCOL# CLUSTER 18049
how can i do to move clutser type objects?
Regards,
1