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
ORA-01691: unable to extend lob segment
You are right and I am trying to resize table size unable to do.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>
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 ??
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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
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
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Who is online
Users browsing this forum: No registered users and 1 guest