Tablo ve Indexlerin Tasinmasi

Tabloları Toplu Halde Taşıma

select 'alter table' || table_name||' move tablespace Hedef_TBS;'
from user_tables
where tablespace_name = 'LOGTBS';

select 'alter table' || table_name||' move tablespace Hedef_TBS;'

from user_tables

where tablespace_name = 'LOGTBS';

select 'alter table SCHEMA_ISMI.' || table_name||' move tablespace HEDEF_TBS;'
from all_tables
where tablespace_name not in 'TABLESPACE_ISMI'
and
owner = 'SCHEMA_ISMI'

select 'alter table SCHEMA_ISMI.' || table_name||' move tablespace HEDEF_TBS;'

from all_tables

where tablespace_name not in 'TABLESPACE_ISMI'

and

owner = 'SCHEMA_ISMI'

Indexleri Toplu Halde Taşıma

select 'alter index ' || index_name||' rebuild tablespace Hedef_TBS;'
from user_indexes
where tablespace_name = 'LOGTBS';

select 'alter index ' || index_name||' rebuild tablespace Hedef_TBS;'

from user_indexes

where tablespace_name = 'LOGTBS';

select 'alter index SCHEMA_ISMI.' || index_name||' rebuild tablespace HEDEF_TBS;'
from ALL_indexes
where tablespace_name NOT IN 'TABLESPACE_ISMI'
AND
OWNER = 'SCHEMA_ISMI';

select 'alter index SCHEMA_ISMI.' || index_name||' rebuild tablespace HEDEF_TBS;'

from ALL_indexes

where tablespace_name NOT IN 'TABLESPACE_ISMI'

AND

OWNER = 'SCHEMA_ISMI';

Hak Verme

select 'grant select, insert, update, delete on MDSYS. ' || table_name || ' to arsivist' from all_tables
where
owner = 'MDSYS'
and
tablespace_name = 'XXXX'

select 'grant select, insert, update, delete on MDSYS. ' || table_name || ' to arsivist' from all_tables

where

owner = 'MDSYS'

and

tablespace_name = 'XXXX'