Re: Running out of rollback
From: Oberle, John F. <DPWCC02.OBERLE02_at_SSW.ALCOA.COM>
Date: 23 Mar 1995 15:57:14 GMT
Message-ID: <3ks5oq$4ss_at_inn-amct.atc.alcoa.com>
Date: 23 Mar 1995 15:57:14 GMT
Message-ID: <3ks5oq$4ss_at_inn-amct.atc.alcoa.com>
>
>Has anyone tried the TRUNCATE command, i.e. TRUNCATE TABLE
<tablename>
>
>I stumbled across this today. Only with version 7, though.
And it
>doesn't create any rollback info, so you best be sure you want
to get rid
>
We are using it in several cases where we have a need to totally
replace the data in a table. It seems to work very well in
those circumstances where you have no need to do a rollback.
John F. Oberle - Usual Disclaimer! Received on Thu Mar 23 1995 - 16:57:14 CET