reclaiming wasted space in Oracle
Date: Tue, 13 May 2014 06:15:25 -0700 (PDT)
Message-ID: <8e31ee66-3776-42dd-a2a8-ae89f65a3d73_at_googlegroups.com>
Welcome,
I would like to reclaim wasted space in tablespaces. I have Oracle 11g Standard Edition, RAC, ASM. I know only this method:
alter table tabName lob(lobKolName) store as (tablespace tmp_clear);
alter table tabName move tablespace tmp_clear;
alter index indName rebuild tablespace tmp_clear;
next:
and move back to USERS tbs...
Is there any better process to do this ? I'm thinking about:
ALTER TABLE table_name ENABLE ROW MOVEMENT;
ALTER TABLE table_name SHRINK SPACE CASCADE;
but it is only on the table level, but what about tablespaces and datafiles ?
Sorry for my pure english...
Regards
ALTER DATABASE DATAFILE file_name || ''' resize 1G;' from dba_data_files where tablespace_name = 'USERS' -- autoextend on maxsize 10G
Robert
Received on Tue May 13 2014 - 15:15:25 CEST