Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Weird advice : keep varchar2 under 255 bytes ???

Re: Weird advice : keep varchar2 under 255 bytes ???

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Apr 2005 06:36:51 -0700
Message-ID: <1113226611.469682.161170@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US