Re: Running out of rollback
From: David Reen <dreen_at_melbourne.DIALix.oz.au>
Date: 28 Mar 1995 13:39:44 +1000
Message-ID: <3l80e0$42p$1_at_melbourne.DIALix.oz.au>
Date: 28 Mar 1995 13:39:44 +1000
Message-ID: <3l80e0$42p$1_at_melbourne.DIALix.oz.au>
Vincen5158 (vincen5158_at_aol.com) wrote:
: >> 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.
I agree ... a very useful command
Be carefull however you need 'DELETE ANY TABLE' priv. and you cannot use
a synonym.
Received on Tue Mar 28 1995 - 05:39:44 CEST