Re: A little baffled by "chained rows"....

> 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 - 12:32:42 CDT