Database Administration (MOSC)

MOSC Banner

How can i reduce size of system datafile ?

edited Jan 6, 2014 5:27AM in Database Administration (MOSC) 12 commentsAnswered
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,

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