Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

one command to move LOB segment AND Lob indexes..

JayDee41Feb 25 2020 — edited Feb 25 2020

Hi Team,

Can anyone help to provide the syntax to move lob segment AND lob index to new SEPARATe tablespaces in one statement..

I see lots of references to moving lob segments and having the respective lob index in the same tablespace as the lob segment.

However I need to separate out the lob segment and lob index into separate tablespaces, preferably in the same 'ALTER TABLE' command..

Something like this:

ALTER TABLE <TABLE_NAME>

MOVE TABLESPACE <TABLESPACE>

(lob (<LOB_COLUMN>)

STORE AS

(TABLESPACE <LOB_SEGMENT_TABLESPACE>

INDEX (TABLESPACE <LOB_INDEX_TABLESPACE>));

Is this correct?

Hope this makes sense.

Any advice much appreciated.

Thanks and regards,

JD

Comments
Post Details
Added on Feb 25 2020
7 comments
352 views