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