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: Incorrect Migrated/Chained rows...

Re: Incorrect Migrated/Chained rows...

From: MAK <maks70_at_comcast.net>
Date: 27 Apr 2004 17:38:04 -0700
Message-ID: <b7178504.0404271638.40945edc@posting.google.com>


Thanks JL for your reply.

> You don't quote an Oracle version - and oddities
> like this can be highly version dependent.
>

Its 9.2.0.3.

> Was there any difference between the table
> parameters you used for the first copy and
> the second copy ? Was the pctfree zero,
> was it unrecoverable ?

No! I was using unrecoverable both the times. I have tried without unrecoverable too but to no avail.

> It is possible that the CTAS did something
> that overestimated the number of rows that
> could get into a block, and then had to correct
> on the fly. (direct path load had a similar problem
> a long time ago).

The table in question has 305 columns ( > 255) , should it make any difference?
>

> One minor detail - in your SQL to check row
> lengths nvl(vsize(col),1) would probably be a
> better approximation, as most columns will have
> an extra one byte for the length. (trailing nulls
> being one exception, and columns longer than
> about 250 bytes which use a 3-byte length).
>

Exellent suggestion! Thanks. Received on Tue Apr 27 2004 - 19:38:04 CDT

Original text of this message

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