-
moving LOBSEGMENT, LOBINDEX into another tablespace
Hi,
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?
Thanks alot!!!
-
Statement below will move table to new tablespace BUT will not move LOB segments from current tablespace...
ALTER TABLE table_name MOVE TABLESPACE target_tablespace
/
Statement below will move segments that make up specific LOB column to new tablespace...
ALTER TABLE table_name
MOVE LOB(clob_column) STORE AS (
TABLESPACE target_tablespace
)
/
Cheers!
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
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.
-
Hi PAVB,
Hmm... i don't quite understand the part about
ALTER TABLE table_name
MOVE LOB(clob_column) STORE AS (
TABLESPACE target_tablespace
)
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????
Thanks so much!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|