Oracle-L: altering next extent

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Fri, 24 May 2002 03:03:22 -0800
Message-ID: <F001.0046A8D2.20020524030322@fatcity.com>

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). Received on Fri May 24 2002 - 06:03:22 CDT