RE: altering next extent solved

The batchjob was doing a truncate, Thx Iain !

Jeroen

-----Oorspronkelijk bericht-----
Van: Nicoll, Iain (Calanais) [mailto:iain.nicoll_at_calanais.com] Verzonden: vrijdag 24 mei 2002 15:16
Aan: 'Jeroen van Sluisdam'
Onderwerp: RE: altering next extent

I believe that if you set the next extent then all extents after that will be set to that size (assuming pct_increase 0). However if you do truncate it removes all but the first extent and sets next extent to the size of the last extent it removed. You would either have to do truncate with the reuse storage option (drop storage is the default) or set next extent when only the initial extent exists i.e. after a truncate and before any growth.

Iain Nicoll

-----Original Message-----
Sent: Friday, May 24, 2002 2:09 PM
To: 'Nicoll, Iain (Calanais)'

Yes there are, is that causing this problem?

Thx,

Jeroen

-----Oorspronkelijk bericht-----
Van: Nicoll, Iain (Calanais) [mailto:iain.nicoll_at_calanais.com] Verzonden: vrijdag 24 mei 2002 14:22
Aan: 'jeroen.van.sluisdam_at_vrijuit.nl'
Onderwerp: RE: altering next extent

There aren't any truncates done on this table are there?

Iain Nicoll

-----Original Message-----
Sent: Friday, May 24, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L

Hi,

It isn't a local managed tablespace problem because I'm still on 7.3.4 db Besides that I'm changing the table specs as far as I know this overrules the tablespace specs.

New is that I created in a new attempt the table on 256K next extent then run the batch again and the storage remains on 256K.

Tia,

Jeroen

-----Oorspronkelijk bericht-----
Van: Rahul [mailto:rahul_at_ratelindo.co.id] Verzonden: vrijdag 24 mei 2002 13:18
Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: altering next extent

LMT ???
> ----------
> From: Jeroen van Sluisdam[SMTP:jeroen.van.sluisdam_at_vrijuit.nl]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, May 24, 2002 6:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: altering next extent
>
> Hi,
>
> I have a strange phenomena. Due to sizing problems with a specific table.
> I changed the next extent clause with
> ALTER TABLE contingenten.BOEKINGEN_ADDITIONS storage ( next 256K );
>
> Mysteriously after running the batch, it was back on 8K.
>
> Ofcourse I select before (also closing sqlplus and starting it again and
> selecting)
> and after the batch the next extent by
> SQL> select next_extent from dba_tables where table_name =
> 'BOEKINGEN_ADDITIONS';
>
> NEXT_EXTENT
> -----------
> 8192
>
> After the batch it was back on 8K. I checked the scripts and there was no
> alter in the script.
> I turned on the audit on this table and did find only records with
> 'session
> rec' in action_name
> What can cause the previous alter to be changed back?
>
> Tia,
>
> Jeroen
>
> Details: oracle 7.3.4 HP-UX 10.20
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeroen van Sluisdam
> INET: jeroen.van.sluisdam_at_vrijuit.nl
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

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).