Portal tablespace is growing up to 20GB
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
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
0