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.
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.
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
Click Here to Expand Forum to Full Width