Thread: Moving a table/index to different tablespace

Moving a table/index to different tablespace

From
Yambu
Date:
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

From
Alvaro Herrera
Date:
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.