still cannot reclaim free space after shrinking tables?
798983Mar 13 2011 — edited Mar 16 2011Hello,
10GR2 database in AIX
I shrinked every table in core schema trying to reclaim free space by using below script.
set lin 500 trimsp on pages 0 echo off ver off feedb off
select 'ALTER TABLE '|| owner || '.' || segment_name || ' enable row movement;' FROM dba_segments where segment_TYPE ='TABLE' and owner = 'coreschema';
select 'ALTER TABLE '|| owner || '.' || segment_name || ' shrink space cascade;' FROM dba_segments where segment_TYPE ='TABLE' and owner = 'coreschema';
select 'ALTER TABLE '|| owner || '.' || segment_name || ' disable row movement;' FROM dba_segments where segment_TYPE ='TABLE' and owner = 'coreschema';
after shrinking, I checked, I still have 71GB free space cannot be reclaimed in data tablespace . anything I missed?
*note: for some tables when shrinking, get error
Error at line 61
ORA-03113: end-of-file on communication channel
I just ignored those tables' shrinking.(very small number of tables), if anyone can tell me why, that is also very helpful
Thanks a lot
Edited by: 795980 on Mar 13, 2011 5:17 PM
Edited by: 795980 on Mar 13, 2011 5:18 PM
Edited by: 795980 on Mar 13, 2011 5:18 PM
Edited by: 795980 on Mar 13, 2011 5:19 PM