row chaining and migration.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: row chaining and migration.

  1. #1
    Join Date
    Feb 2001
    Posts
    66
    Hi,
    I have a database(oracle 8i) with more than 200 tables. All tables are on the same tablespace with the oracle default setings, so tablespace storage parameters are used. When I monitor for row chaning, there are 4 tables with clobs that have about 20% of rows chained.
    I know that if the clob size is more than 4000 char, is just the locator that are keept on the same extent, the value will be stored on another extent.
    Should I keep the tables with clobs on a larger extent tablespace?, is there a way to tell to oracle to keep only locators on the same extent and values on another. I mean, there is no way for me to know if the user will have more than 4000 characters to insert.

    thanks,
    marian

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    In such a case, it would be better to export all data, drop and recreate the table with appropriate storage settings and then import data into the new structure.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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