ORA-01691: unable to extend lob segment

[kamran.it]

Using 8.0.5
oracle 6i
windows 2003 server

Dear Friends

I have table

SQL> desc ppimage
Name Null? Type
------------------------------- -------- ----
MPPNO NUMBER(6)
MSUBPP VARCHAR2(2)
ACCES VARCHAR2(10)
IMAGE BLOB



our user have inserted 494 picturs but Now when users try to insert another picture in this table show the error

ORA-01691: unable to extend lob segment

please help

best regards

[admin]

Seems your Tablespace is full check if it is auto extendible or manual for manual you will have to increase its size. thanks

[kamran.it]

Seems your Tablespace is full check if it is auto extendible or manual for manual you will have to increase its size. thanks

<i><div align="right">Originally posted by admin - 08/12/2006 : 10:41:26 PM</div id="right"></i>

You are right and I am trying to resize table size unable to do.

Let me know some thing it is right steps

1. first I granted :
Grant DBA to User;
(done without any error.)
2. connect user/password

3. now tell me I have to add a tablespace
I did this :

Code: Select all

1* create tablespace kame datafile 'D:\ORACLE\FORMS\ahmed'
  2  /
create tablespace kame datafile 'D:\ORACLE\FORMS\ahmed'
*
ERROR at line 1:
ORA-01119: error in creating database file 'D:\ORACLE\FORMS\ahmed'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified. 

Please help me what should I do ??

[ahmadbilal]

CREATE TABLESPACE "AHMAD"
LOGGING
DATAFILE 'C:\ORACLE\ORADATA\DAWDB\AHMAD.ora' SIZE 500M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO


Modify as per your requirement

[kamran.it]

CREATE TABLESPACE "AHMAD"
LOGGING
DATAFILE 'C:\ORACLE\ORADATA\DAWDB\AHMAD.ora' SIZE 500M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO


Modify as per your requirement

<i><div align="right">Originally posted by abmian1981 - 09/12/2006 : 12:00:11 AM</div id="right"></i>

I have altered tablespace and added data file with 500m size I use this line
alter tablespace &tbs_name add datafile 'location_of_file' size &put_size_according_you;
and 2 data file i have added.


still shows error
FRM-40508 Oracle Error Unable to insert record.

when I see display error in the help in form 6i in our software

ORA-01691: unable to extend lob segment

[admin]

Press SHIFT+F1 keys to get exact cause of the error. Secondly also try to insert some data in the same tablespace directly from sqlplus or any other form so just to confirm what is the exactly issue. It is possible that your tablespace is readonly or.... When you will be able to insert data in this tablespace then the next point we will adress is specific to lob. Pl insert sufficient data in the temporary table. thanks

[ahmadbilal]

ALTER TABLESPACE "AHMAD"
ADD
DATAFILE 'C:\ORACLE\ORADATA\DAWDB\AHMAD.ora' SIZE 2M
AUTOEXTEND
ON NEXT 5M MAXSIZE UNLIMITED


After sucessfuly Applying this Command You Dont Need Extend this Table Space You Just Need to Do care of your Disk Size.