Re: Speed up Truncate tables

And you can also shrink the initial extent with 'deallocate unused' if the HWM if inside the first extent.

Jonathan Lewis

Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 15 August 2001 20:14

|Not true, at least in 8i. Using 'alter table move ' you could change
the
|initial extent size..
|
|SQL>alter table test move storage (initial 2M);
|
|Table altered.
|
|Only catch here is that 'move' command doesn't apply to tables having
long
|,long raw, LOB etc..Initial extent can be changed for the remaining
|tables..
|
|Thanks
|Riyaj "Re-yas" Shamsudeen
|Certified Oracle DBA
|i2 technologies www.i2.com
|
|
|
|
|Christopher Spence <cspence_at_FuelSpot.com>
|Sent by: root_at_fatcity.com
|08/15/01 02:22 PM
|Please respond to ORACLE-L
|
|
| To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
| cc:
| Subject: RE: Speed up Truncate tables
|
|
|You are correct, unless your using 9i, you cannot alter the initial
extent
|without dropping the table.
|
|"Do not criticize someone until you walked a mile in their shoes,
that way
|when you criticize them, you are a mile a way and have their shoes."
|
|Christopher R. Spence
|Oracle DBA
|Phone: (978) 322-5744
|Fax: (707) 885-2275
|
|Fuelspot
|73 Princeton Street
|North, Chelmsford 01863
|

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).