Re: Chained_Rows
From: <jdorlon_at_my-deja.com>
Date: Fri, 19 Jan 2001 15:28:59 GMT
Message-ID: <949mfe$h5r$1_at_nnrp1.deja.com>
Date: Fri, 19 Jan 2001 15:28:59 GMT
Message-ID: <949mfe$h5r$1_at_nnrp1.deja.com>
forgot to mention...
if your table is not that big, you might just want to do this :
- create table y with the same stucture as X (X being the one with chained rows)
- insert into Y select * from X
- truncate table X
- insert into X select * from Y
- commit
- drop table Y.
If your table is small, this method is much easier. same rule applies with FK constraints and triggers, disable them first.
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 19 2001 - 16:28:59 CET