ORA-01691: unable to extend lob segment [message #208083] |
Fri, 08 December 2006 01:57 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
Using 8.0.5
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 rows but Now when users try to insert picture in this table show the error
ORA-01691: unable to extend lob segment
I think I have to resize our table space but I dont have any idea how to resize
please help
best regards
|
|
|
|
|
|
|
|
Re: ORA-01691: unable to extend lob segment [message #208275 is a reply to message #208273] |
Sat, 09 December 2006 00:30 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
when I try to connect on SQL
SQL> connect / as sysdba;
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> connect sys as sysdba;
ERROR:
ORA-01031: insufficient privileges
|
|
|
|
Re: ORA-01691: unable to extend lob segment [message #208286 is a reply to message #208283] |
Sat, 09 December 2006 01:32 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
Deat Taj
I have a table ppimage
SQL> desc ppimage
Name Null? Type
------------------------------- -------- ----
MPPNO NUMBER(6)
MSUBPP VARCHAR2(2)
ACCES VARCHAR2(10)
IMAGE BLOB
I didnt add any tablespace at the time of creating this table and current oracle user , now we cannot add picture in this table because defualt size increased what can I do??
== Now I have to create tablespace because i didnt create. if yes then how to create? table name is ppimage must be define with tablespace or login user will also invlove in this situation.
[Updated on: Sat, 09 December 2006 01:40] Report message to a moderator
|
|
|
Re: ORA-01691: unable to extend lob segment [message #208287 is a reply to message #208286] |
Sat, 09 December 2006 01:41 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
hi
go through below procedure.
select table_name, tablespace_name
from dba_tables
where TABLE_NAME = 'PPIIMAGE' or OWNER = '&owner_of_table_user';
here you get tablespace name where table is created.
now add datafile on above tablespace.
alter tablespace &tbs_name add datafile 'location_of_file' size &put_size_according_you;
hope this helps
Taj
[Updated on: Sat, 09 December 2006 01:41] Report message to a moderator
|
|
|
Re: ORA-01691: unable to extend lob segment [message #208288 is a reply to message #208287] |
Sat, 09 December 2006 01:48 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
Dear Taj
Please see I did
SQL> desc ppimage
Name Null? Type
------------------------------- -------- ----
MPPNO NUMBER(6)
MSUBPP VARCHAR2(2)
ACCES VARCHAR2(10)
IMAGE BLOB
SQL> select table_name, tablespace_name
2 from dba_tables
3 where TABLE_NAME = 'PPIIMAGE' or OWNER = '&owner_of_table_user';
Enter value for owner_of_table_user: scott;
old 3: where TABLE_NAME = 'PPIIMAGE' or OWNER = '&owner_of_table_user'
new 3: where TABLE_NAME = 'PPIIMAGE' or OWNER = 'scott;'
no rows selected
|
|
|
|
|
|
Re: ORA-01691: unable to extend lob segment [message #208307 is a reply to message #208306] |
Sat, 09 December 2006 05:09 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
our user have inserted 494 pictures but Now when users try to insert picture in this table show the 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
|
|
|
|
|
|
Re: ORA-01691: unable to extend lob segment [message #208314 is a reply to message #208313] |
Sat, 09 December 2006 06:35 |
kamran.it
Messages: 265 Registered: September 2005 Location: Karachi
|
Senior Member |
|
|
Let me know one thing
ppimage is a table and in this table 494 pictures are saved I dont know how much MB covered.
I addedd 2 datafile (image.dbf,image1.dbf) with this table (ppimage) now oracle will shfit more pictures in these datafile ??
and now I am inserting pictures having 142KB size I think it should be add.
|
|
|
|
|
|
|