Is the batch job doing a TRUNCATE table ?
Hemant K Chitale ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, 24 May, 2002 8:08 PM > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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).
