Обсуждение: Moving a table/index to different tablespace

Поиск
Список
Период
Сортировка

Moving a table/index to different tablespace

От
Yambu
Дата:
Hi

May i know if there is any risk in moving a table or index to a different tablespace during usage?

regards

Re: Moving a table/index to different tablespace

От
Alvaro Herrera
Дата:
On 2020-Dec-03, Yambu wrote:

> Hi
> 
> May i know if there is any risk in moving a table or index to a different
> tablespace during usage?

There's no risk as such, but an access exclusive lock will be acquired
during the move, which will prevent all other access to that table or
index.