Can't srhink tablespace SYSTEM
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
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
0