A truncate with the "reuse storage" clause on it will also retain the
existing extent usage.
> -----Original Message-----
> From: bill thater [SMTP:thaterw_at_telergy.net]
> Sent: Wednesday, May 03, 2000 10:47 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Newbie Question - weird extents
>
> On May 3, Rocky Welch scribbled on the wall in glitter crayon:
>
> ->Hi Christy,
> ->What tool were you using to check the extents?
>
> could it also have been that a lot of insert/delete pairs were run on
> those
> tables leaving only a few records in place?
>
> ->
> ->--- "Warthling, Christy" <cwarthling_at_CharterOneBank.com> wrote:
> ->> Hi all -
> ->>
> ->> Being new to Oracle, I'm not sure if this is a common occurrence or if
> ->> it
> ->> indicates anything in particular.
> ->>
> ->> We have an application (Lawson) using Oracle 8.1.5 (on NT, more's the
> ->> pity).
> ->> I have been checking file sizes pretty religiously since I'm new, the
> ->> system
> ->> is new, and we just went into production.
> ->>
> ->> Yesterday a consultant (very helpful one, btw) was here helping me
> with
> ->> some
> ->> other issues, and we noticed that two of the tables seemed to have an
> ->> oddly
> ->> large number of extents (one had 49, one had 36 or so). Strange,
> ->> considering that each table had only 14 records and the initial extent
> ->> should have been plenty large enough to hold way more than that. We
> ->> ended
> ->> up exporting/truncating tables/recreating/importing the data, which
> ->> worked
> ->> fine.
> ->>
> ->> But I'm curious to know if there's any way I can figure out why they
> ->> seemed
> ->> to break up like that - what do you all think?
> ->>
> ->> TIA for any ideas -
> ->>
> ->> Christy
> ->> cwarthling_at_charteronebank.com
>
> --
> Bill Thater Certified ORACLE DBA
> Telergy, Inc. thaterw_at_telergy.net
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Do or not do. There is no try. -- Yoda
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Study = NoFail NoStudy = Fail .............. Study + NoStudy = Fail + No
> Fail Study(1 + No) = Fail(1 + No) ergo, Study = Fail
>
>
>
>
>
> --
> Author: bill thater
> INET: thaterw_at_telergy.net
>
> 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
Received on Wed May 03 2000 - 14:10:49 CDT
