Database Administration (MOSC)

MOSC Banner

Portal tablespace is growing up to 20GB

edited Oct 21, 2009 4:20AM in Database Administration (MOSC) 4 commentsAnswered
Our Portal tablespace is growing up to 20GB, but is really used for 9%. We cannot resize the datafile because (I think) the HWM blocks the command with "ORA-03297: file contains used data beyond requested RESIZE value".
Can we enable "row movement" on Portal db objects and use "alter table shrink space" to reduce HWM?
In all objects? Because the "Segment Advisor" of database reports less of 300MB like "reclaimable space" in 5 objects !

Please advise on options from a DB perspective.

Our database is 10.2.0.3 and our OS is linux 86

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