Re: Running out of rollback

From: Vincen5158 <vincen5158_at_aol.com>
Date: 23 Mar 1995 22:23:03 -0500
Message-ID: <3ktdun$h3b_at_newsbf02.news.aol.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

This is a great command if you are using work tables (ie, tables that are used temporarily for reporting, etc.). Its like a drop table command but all grants, indexes, constraints, etc. are maintained. Received on Fri Mar 24 1995 - 04:23:03 CET

Original text of this message