-1653: ORA-01653: unable to extend table

muttleychess

But It out error, before commit

can I other hint ? ( nologging ) ,

How can I to resolve this error, without to use Cursor ?

Satish Kandi

What is the output of following query?

select count(extent_id) from dba_extents where tablespace_name='ATTRIBUTE';

muttleychess

tks

6566

502493

maybe it's the append hint causing the problem. a bit of a similar problem is discussed here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:15571223360424060549::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6273519667276

587034

Try this,

Alter table table_name storage(next_extent 32K);

kindly check the extend you want to set.


Regards,
Uday Patil