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: Chained Rows

Re: Chained Rows

From: Jared Hecker <jared_at_hwai.com>
Date: 1997/04/02
Message-ID: <33426ab1.167461426@news.planet.net>#1/1

Basically it means your table storage parameters should be reexamined - especially PCTFREE and NEXT_EXTENT. Recalculate the maximum record length and resize accordingly. Algorithms are in the doc set, I think in the Server Reference.

To fix: export it, drop and recreate it with new storage parameters, import it.

hth -

jh

On Tue, 01 Apr 1997 20:34:13 GMT, theo.verbinnen_at_innet.be wrote:

>hi all,
>
>
>i found out that five system tables contain chained rows?
>is this a normal situation? I guess not but what to do about it?
>thanks for your help........
>
Received on Wed Apr 02 1997 - 00:00:00 CST

Original text of this message

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