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: Inserts and row chaining

Re: Inserts and row chaining

From: Helge Petersen <petersen_at_com1.dwhl.de>
Date: 1997/01/23
Message-ID: <petersen.854013961@com1.dwhl.de>#1/1

chuckh_at_dvol.com (Chuck Hamilton) writes:

[snip]

>Please corrent me if I'm wrong but I think the answer is no. Only an
>update can cause a chaned row.
>--
>Chuck Hamilton
>chuckh_at_dvol.com

But what about a db_block_size of 2048 (2k) and inserts with e.g. two completely filled varchar(2000) fields ?

How does Oracle store these rows ?

Thanks,
Helge


Helge Petersen                          Database- and Systemadministrator
Draeger Synematic GmbH                  D-23558 Luebeck, Germany
Tel. 0451/882-4044   Fax -3031          Email helge.petersen_at_draeger.com
***************************************************************************
Received on Thu Jan 23 1997 - 00:00:00 CST

Original text of this message

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