Problemas com TableSpace – U R G E N T E

[MauroLacerdaParticipante]

Um Script para gerar tudo para voce, tabelas e indices.

set pagesize 12000
set linesize 100
conn /
spool c:scriptsskr_.sql
select ‘alter TABLE ‘||owner||’.’||object_name||’ ENABLE ROW MOVeMENT;’ from ALL_objects where
owner IN (‘XXX’,’YYY’) AND OBJECT_TYPE=’TABLE’ ;
select ‘alter index ‘||owner||’.’||object_name||’ SHRINK SPACE;’ from ALL_objects where
owner IN ((‘XXX’,’YYY’) AND OBJECT_TYPE=’INDEX’ ;
select ‘alter TABLE ‘||owner||’.’||object_name||’ SHRINK SPACE;’ from ALL_objects where
owner IN (‘XXX’,’YYY’) AND OBJECT_TYPE=’TABLE’ ;
spool off;

Boa Sorte!