Oracle Spostamento Oggetti: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con "==Spostamento Indici== ==Spostamento LOB== Categoria:Oracle Categoria:Database") |
|||
Riga 1: | Riga 1: | ||
==Spostamento Indici== |
==Spostamento Indici== |
||
set pagesize 200 |
|||
set linesize 200 |
|||
set trim on |
|||
set trims on |
|||
select 'alter index ' || owner || '.' || index_name || ' rebuild tablespace GW_IDX online nologging compute statistics;' from dba_indexes where tablespace_name='GW_DAT'; |
|||
prompt 'ALTER SESSION SET ddl_lock_timeout=30;' |
|||
select 'alter index ' || owner || '.' || index_name || ' logging;' from dba_indexes where LOGGING='NO' and owner !='PERFSTAT'; |
|||
==Spostamento LOB== |
==Spostamento LOB== |
Versione delle 10:27, 15 mag 2018
Spostamento Indici
set pagesize 200 set linesize 200 set trim on set trims on
select 'alter index ' || owner || '.' || index_name || ' rebuild tablespace GW_IDX online nologging compute statistics;' from dba_indexes where tablespace_name='GW_DAT'; prompt 'ALTER SESSION SET ddl_lock_timeout=30;' select 'alter index ' || owner || '.' || index_name || ' logging;' from dba_indexes where LOGGING='NO' and owner !='PERFSTAT';