ora -01691 Unable to extend LOB... [message #116219] |
Mon, 18 April 2005 11:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #116240 is a reply to message #116225] |
Mon, 18 April 2005 15:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|