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 10:28:22 -0700
Message-ID: <b7178504.0404270928.67f60ab8@posting.google.com>


> What do you get if you do the following:
>
> create table temp_s_contact_03
> pctfree 15 pctused 80 inittrans 5 unrecoverable
> as (select * from s_contact
> where rowid in ( select head_rowid from chained_rows where table_name
> = 'S_CONTACT'));
More migrated rows!! 7240 rows to be precise.

Thanks Received on Tue Apr 27 2004 - 12:28:22 CDT

Original text of this message

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