How to move a lob segment and a lob index to a differrent tablespace.


How to rebuild a LOB Index in oracle

Normally you cannot move or rebuild a lob index to another tablespace like normal table. so you have to use little difference syntax. this is bellows .... 


ALTER TABLE MOVE LOB ()
STORE AS (TABLESPACE   );

 



Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post