Home » Server Options » Spatial » ORA-13193: failed to allocate space for geometry
icon8.gif  ORA-13193: failed to allocate space for geometry [message #172679] Wed, 17 May 2006 10:57 Go to next message
ykevanranden
Messages: 4
Registered: July 2005
Location: Wageningen
Junior Member
ORA-13193: failed to allocate space for geometry Embarassed
ORA-06512: at "MDSYS.SDO_3GL", line 439
ORA-06512: at "MDSYS.SDO_GEOM", line 3034
ORA-06512: at "MDSYS.SDO_GEOM", line 3050

I get this error using a certain query in which i select a geometry object an create a buffer using a value from a column.

SO

select sdo_geom.sdo_buffer(point, 5,1) from table works fine

however if i use

select sdo_geom.sdo_buffer(point, avg_signal,1) from table

i get the above error.

I validated all the geometries in the table and they al validate as true. It work fine this afternoon and on a certain moment it simply ditd not work any more. I restarted my database, my machine however none solves the problem.
Re: ORA-13193: failed to allocate space for geometry [message #172689 is a reply to message #172679] Wed, 17 May 2006 11:51 Go to previous message
ykevanranden
Messages: 4
Registered: July 2005
Location: Wageningen
Junior Member
I found the problem.

Adding a buffer with radius 0 was the problem.
Previous Topic: Getting Errors
Next Topic: ORA-00939: too many arguments for function
Goto Forum:
  


Current Time: Sun Nov 23 11:29:51 CST 2014

Total time taken to generate the page: 0.24740 seconds