Database Administration (MOSC)

MOSC Banner

Can't srhink tablespace SYSTEM

edited Apr 28, 2010 11:34PM in Database Administration (MOSC) 4 commentsAnswered
Hi people,
My SYSTEM tablespace has 8G allocated but uses only 700M. I've tried to shrink it but returns "ORA-03297: file contains used data beyond requested RESIZE value". Using "Show tablespace contents" on grid control, I did notice that some sys tables are using a  few blocks ate the end of the data file.

Some of those tables has LONG data types which won't allow to move to another tablespace and move back to release all the unusable space.

Does any one have any idea of how to reduce its size??

DB version: 11.2.0.1
OS: Linux Red Hat 5 update 2
Environment: Development

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