Re: ALTER TABLE STORAGE doesn't effect next extent

In article <CAIGER.93May11124316_at_ress1.afrc.ac.uk> caiger_at_resa.afrc.ac.uk (Andy Caiger -RESCU) writes:
>
>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 nothing is wrong with your table. The tablespace that it is in is full. You should either drop useless tables from that tablespace or alter the tablespace and add a datafile (see the alter tablespace command).

-jf Received on Fri May 14 1993 - 18:19:51 CEST