ALTER TABLE STORAGE doesn't effect next extent

Hello,

Can anyone suggest what is going wrong with the following:

I have written a bit of PRO*C code that attempts an INSERT into a table, and traps any failure due to errors like:

ORA-01547: failed to allocate extent of size X in tablespace 'N'

It then uses ALTER TABLE ... STORAGE (NEXT n PCTINCREASE p) to change the storage characteristics of the table, so that repeating the INSERT will result in a smaller extent being allocated.

I've checked the data dictionary table 'user_tables' and the ALTER TABLE command definitely changes the right NEXT_EXTENT and PCT_INCREASE values, but the INSERT command still tries to create the same sized extent. Why ? How do you get the ALTER TABLE to have its effect ?

I'd be grateful for any suggestions...

yours puzzledly,

                 Andy



-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Andy Caiger                                     Rothamsted Experimental Station
                                                  Harpenden, Herts. AL5 2JQ. UK
e-mail: caiger_at_resa.afrc.ac.uk                          +44 (0)582 763133 x2418

--


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Andy Caiger                                     Rothamsted Experimental Station
                                                  Harpenden, Herts. AL5 2JQ. UK
e-mail: caiger_at_resa.afrc.ac.uk                          +44 (0)582 763133 x2418


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-