Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Speed up Truncate tables
<SPAN
class=571542819-15082001>Cool! I just tried it - works like a
charm!
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional
<FONT face=Tahoma
size=2>-----Original Message-----From: Riyaj_Shamsudeen_at_i2.com
[mailto:Riyaj_Shamsudeen_at_i2.com]Sent: Wednesday, August 15, 2001
4:02 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Speed up Truncate tables<FONT face=sans-serif
size=2>Not true, at least in 8i. Using 'alter table move ' you could change
the initial extent size.. <FONT face=sans-serif
size=2>SQL>alter table test move storage (initial 2M); <FONT face=sans-serif size=2>Table altered. <FONT face=sans-serif size=2>Only catch here is that 'move' command doesn't apply to tables havinglong ,long raw, LOB etc..Initial extent can be changed for the remaining tables.. ThanksRiyaj "Re-yas"
Christopher Spence
<cspence_at_FuelSpot.com> <FONT face=sans-serif
size=1>Sent by: root_at_fatcity.com 08/15/01 02:22 PM <FONT face=sans-serif size=1>Please respond to ORACLE-L <FONT face=sans-serif size=1> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> <FONT face=sans-serif
size=1> cc: Subject: RE: Speed up Truncate tables<FONT face="Courier New"
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Kevin Lange INET: kgel_at_ppoone.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.usFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- <FONT face="Courier New" size=2>Author: INET: lhoska_at_calibresys.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Christopher Spence INET: cspence_at_FuelSpot.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like
![]() |
![]() |