ORA-22853

[ShadiQandil]

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

[VinceAngelo · Accepted solution]

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

[ShadiQandil]

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