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