moving LOBSEGMENT, LOBINDEX into another tablespace
Presently, i intend to move some tables from tablespace A to tablespace B. However, i found that in tablespace A, there are objects with type LobIndex and LobSegment. In this case, will it cause any problems to move the tables using the ALTER TABLE ... MOVE command?
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
ALTER TABLE table_name MOVE LOB(clob_column) STORE AS (
If the objects with type LobIndex and LobSegment are named 'SYS1234' with columns 'AA', 'BB', 'CC', does that mean that i have to specify all the columns names e.g. 'AA', 'BB', 'CC' in place of clob_column?
Does this syntax works for both LobIndex and LobSegment types????