Tabloları Toplu Halde Taşıma
|
1 2 3 |
select 'alter table' || table_name||' move tablespace Hedef_TBS;' from user_tables where tablespace_name = 'LOGTBS'; |
|
1 2 3 4 5 |
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
|
1 2 3 |
select 'alter index ' || index_name||' rebuild tablespace Hedef_TBS;' from user_indexes where tablespace_name = 'LOGTBS'; |
|
1 2 3 4 5 |
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
|
1 2 3 4 5 |
select 'grant select, insert, update, delete on MDSYS. ' || table_name || ' to arsivist' from all_tables where owner = 'MDSYS' and tablespace_name = 'XXXX' |
ColdBackup (user backup)...
12 Mart 2019