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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).