moving LOBSEGMENT, LOBINDEX into another tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: moving LOBSEGMENT, LOBINDEX into another tablespace

  1. #1
    Join Date
    Aug 2007
    Posts
    62

    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!!!

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Aug 2007
    Posts
    62
    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
  •  



Click Here to Expand Forum to Full Width