Home » RDBMS Server » Server Administration » ora -01691 Unable to extend LOB...
ora -01691 Unable to extend LOB... [message #116219] Mon, 18 April 2005 11:02 Go to next message
oskarthik
Messages: 26
Registered: March 2005
Junior Member
Hi all,
oracle v :8.1.7
Os :RH Linux 9
f/e :Delphi

we encountered an ora-01691 error unable to extend lob for a table which was just imported.

Besides adding a new datafile for LOB of size 2G


We set the next extent to 512k
max extents to unlimited
an RBS created and made online

we still get the error
Any clue
Thanx
Karthik
Re: ora -01691 Unable to extend LOB... [message #116225 is a reply to message #116219] Mon, 18 April 2005 11:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are you LMT?
Else
Make sure you have storage as INITIAL=NEXT and PCITINCREASE=0.
and always
DO the export with compress=N
Re: ora -01691 Unable to extend LOB... [message #116240 is a reply to message #116225] Mon, 18 April 2005 15:04 Go to previous messageGo to next message
oskarthik
Messages: 26
Registered: March 2005
Junior Member
hi is it possible to just extend the segment required. like if i get an error message like

unable to extend lob segment SAMPLOB.SYS_LOB0000004289C00007$ by 25600 in tablespace LOB

can i just extend the required segment? How ?



thanx
karthik
Re: ora -01691 Unable to extend LOB... [message #116248 is a reply to message #116240] Mon, 18 April 2005 17:30 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
extend the tablespace size.
i.e, add more datafiles and let them have autoextend ON.
Previous Topic: ORA-04020 deadlock detected
Next Topic: More than 1 ROWIDs for 1 single record
Goto Forum:
  


Current Time: Fri Sep 27 02:37:18 CDT 2024