 Меню сайта |
|
| Форма входа |
|
| Категории раздела |
|
| Поиск |
|
| Статистика |
Онлайн всего: 1 Гостей: 1 Пользователей: 0 |
|
| Приветствую Вас, Гость · RSS |
20.05.2024, 07:46 |
|
Moving segments between tablespaces
Unpartitioned table:
alter table TABLE_NAME move tablespace tbs_new_tablespace
Unpartitioned lob
ALTER TABLE TABLE_NAME MOVE LOB (column_name) STORE AS (TABLESPACE tbs_new_tablespace);
Partition table:
alter table TABLE_NAME move partition SYS_P4653 tablespace tbs_new_tablespace
Partitioned LOB:
select * from dba_lob_partitions
where
table_owner = 'OWNER'
-- and lob_partition_name = 'SYS_LOB_P4609'
and table_name = 'TABLE_NAME'
alter table object_history move partition P_0 lob (column_name) store as ( tablespace tbs_new_tablespace )
When log segment being moved in such a way lob index moves also. BUT the size of the moved segment remains the same independently of the extent size of the new tablespace;
Index:
alter index index_name rebuild tablespace tbs_new_tablespace
|
| Категория: Все про Oracle | Добавил: basil (13.06.2013)
|
| Просмотров: 575 | Комментарии: 2
| Рейтинг: 0.0/0 |
|
|
