Re: TRUNCATE Table Command

From: Tony Jambu <aaj_at_phantom.telecom.com.au>
Date: 1995/06/21
Message-ID: <3s7rij$3ui_at_newsserver.trl.OZ.AU>#1/1


In article <1995Jun15.180113.6313_at_dhnews.dehavilland.ca>, t89003_at_isdserv.dehavilland.ca (Rennick Sandra) writes:
>
> We have just encountered an interesting situation using the TRUNCATE TABLE
> command with the DROP STORAGE option. We have a table that was originally
> defined with a NEXT extent of 1M. Several weeks ago, we changed the NEXT
> extent to be 10M. After we truncated the table, the NEXT extent was
> redefined to the original value of 1M. Not knowing that this would happen,
> we then attempted to import data into the table, and ran out of extents.
>
> Has anyone seen this before? Can anyone explain why this happened?

It is documented in the manuals. If it is causing your hassles, why not just use the REUSE STORAGE option to TRUNCATE?

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                  |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905
Received on Wed Jun 21 1995 - 00:00:00 CEST

Original text of this message