Mover tabelas e índices para outra tablespace
Índices select ‘alter index ‘|| owner ||’.’||segment_name||’ rebuild tablespace USERS;’from dba_segmentswhere 0=0and owner = ‘xxxx’and tablespace_name<>’USERS’and segment_type=’INDEX’; Tabelas select ‘alter table ‘||owner ||’.’||segment_name||’ move tablespace USERS;’from dba_segmentswhere owner=’xxxxx’and tablespace_name<>’USERS’and segment_type=’TABLE’;...