Thanks Howard. Glad to see you back and enjoyed your postings on this group.
"Jack Wang" <nospam_at_nospam.com> wrote in message
news:_w9_a.62$zE1.43_at_edtnps84...
> > insert into blah select * from X; (re-inserts the old rows, and because
> > it's an insert, they can't possibly migrate).
>
> Yes, this solves row migration. But if the length of inserted row exceeds
> block size, row chaining would still occur? Any suggestion on how to avoid
> chained row in such case? Is it necessary to re-design the table structure
> to use CLOB in replace of char/varchar2?
>
> Thanks.
> Jack
>
>
>
Received on Tue Aug 12 2003 - 20:04:14 CDT
