Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Weird advice : keep varchar2 under 255 bytes ???
JM, ask the developer to produce a source for that nonsense.
If the varchar2 value is not inserted on the initial row insert or is later greatly expanded then it may be necessary to set the table pctfree to a larger value to prevent migrated rows from occurring, but it you declare the column as say varchar2(400) and on the initial row insert the column is populated then Oracle will store the rows just as it does any other row. Longer rows without adequate pctfree increase the odds of migrated rows and longer rows in general can lead to row chaining though row chaining is not a problem. It just means you have rows larger than an Oracle database block.
HTH -- Mark D Powell -- Received on Mon Apr 11 2005 - 08:36:51 CDT