Re: Problem with table size

A couple of questions... Is the long text field filled in when the record is added, or is it often updated to its final value afterwards?
(Something must be placed in it because of the NOT NULL constraint).
What is your PCTFREE set to? How much updating occurs to the record after it is added? Why not use varchar2 on the other character fields?
(This is not likely your problem, but could save you some space.) Is an
export/import possible to do within your availability window? What is your blocksize? I suspect that a lot of chaining is occurring, but it is hard to tell with the information provided. What is the life of a row before the numbers wrap and it gets deleted? I would also create the table with the long field as the last column...

Thanks, Received on Thu May 22 1997 - 00:00:00 CDT