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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Fixed- vs. Variable-width tables

Re: Fixed- vs. Variable-width tables

From: Brian Dick <bdick_at_cox.net>
Date: Thu, 21 Mar 2002 15:19:35 GMT
Message-ID: <bSmm8.37741$PL1.1327653@news2.east.cox.net> 





There are only two fixed length data types in Oracle, and they are char and
date. I wouldn't want to create a database only using those types.



Oracle uses PCTFREE to reserve space on a block for row expansion. Once a
block reaches the PCTFREE, it no longer accepts inserts (off the free list).
If rows are deleted or shrunk down to the PCTUSED, it again accepts inserts
(on the free list).


--
Later,
BEDick


Received on Thu Mar 21 2002 - 09:19:35 CST












Original text of this message













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