Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Incorrect Migrated/Chained rows...
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