Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> altering next extent

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US