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

Thread: row chaining and migration.

  1. #1
    Join Date
    Feb 2001
    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.


  2. #2
    Join Date
    Aug 2001
    Waterloo, On
    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

  3. #3
    Join Date
    Jan 2002
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    --- 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