topic ORA-22853 in Data Management Questions

ORA-22853

ShadiQandil — Thu, 26 Jun 2014 08:21:04 GMT

I was trying to create a field "RASTER Data type" in a polygon feature class. I received the error below:

ORA-22853 invalid lob storage option specification.

ORACLE is 11.2.0.1

ArcSDE 10.1

Windows 2008 R2 64-bit.

Any suggestions?

Regards,

Shadi A. Qandil

Re: ORA-22853

VinceAngelo — Thu, 26 Jun 2014 10:35:23 GMT

You should review the layout of the relevant DBTUNE keyword keys to determine
where the DDL syntax error resides.

Or you can use modern ArcGIS best practice, and avoid using rasters in databases
altogether. Raster Datasets are where all the new development is being done.

I certainly hope you are using the SP1 and QIP updates to ArcGIS 10.1, not a "raw"
ArcGIS 10.1 release.

- V

Re: ORA-22853

ShadiQandil — Wed, 02 Jul 2014 08:57:41 GMT

You should review the layout of the relevant DBTUNE keyword keys to determine
where the DDL syntax error resides.

Or you can use modern ArcGIS best practice, and avoid using rasters in databases
altogether. Raster Datasets are where all the new development is being done.

I certainly hope you are using the SP1 and QIP updates to ArcGIS 10.1, not a "raw"
ArcGIS 10.1 release.

- V

Dear Vince,

Thank you for your help. I reviewed the dbtune.sde file and fixed the error.

Regards,

Shadi A. Qandil