Re: 8.1.7.4 - Linux - Tablespace Issue

>
> I have a tablespace that apparently does not have sufficient space to
> extend any further - No issue as i added a datafile to it.
>
> Still getting the same error so i checked the freespace in the
> tablespace and this is the report for that tablespace
>
> Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
> JServer Release 8.1.7.4.0 - Production
>
>
> Tablespace free space
> TSNAME TOTAL(M) FREE(M) FREE % LARG(M) FRAGMTS MGMT
> ALLO
> ------------------------- -------- -------- ------ -------- ------- ----
> ----
> xxxxxBLOB 10,900 5,563 51 1,498 7 PERM
> USER
>
> however i'm getting this in the alert log
>
> ORA-1691: unable to extend lobsegment xxxxx.SYS_LOB0000071706C00002$$ by
> 311072 in tablespace xxxxxBLOB

OK this is really confusing me now as i'm only trying to insert a 3meg image and i first created a file with inital size of 100meg and next extent 10meg so there should be plenty of continous space. Any ideas as i'm not getting anywhere fast

thanks! Received on Thu Dec 08 2005 - 08:01:46 CST