question

BI DWH BALA avatar image
BI DWH BALA asked

Tablespace movement of a table.

Hi,

I have a table which is created in Tablespace A. Now I want to change the tablespace of this table to Tablespace B.

Will the indexes be valid after this?

Thank you, regards

BI DWH BLA

tablespace
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
dmann avatar image
dmann answered

Indexes point to the location of physical blocks on disk, so no. If you change the location of the table the indexes will be invalid.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.