Geocoding throws an Error ORA-01455

City_ofsanjose — Sun, 05 Aug 2012 23:01:12 GMT

I've a non-graphic table in Oracle with about 50,000+ records and registered it within ArcSDE with a OBJECTID number (38). The table registers successfully but when I open the attribute and say end, I get the following error:

There was an erro trying to process this table. Underlyning DMBS error [ORA-01455: converting column overflows integer datatype FIN.BUSINESS_LOCATION. I get the same error while I try to geocode the able table.

CREATE TABLE FIN.BUSINESS_LOCATION
( OBJECTID          NUMBER(38)                  NOT NULL,
ACCT_ID           NUMBER(10),
BUSINESSNAME      VARCHAR2(50 BYTE),
ADDRESS           VARCHAR2(200 BYTE),
ICDISTRICT        NUMBER(5),
BUSINESSTYPE      VARCHAR2(50 BYTE),
BUSINESSCATEGORY VARCHAR2(50 BYTE)
);

I ran the following commands to change the datatype but to no avail.

sdetable -o describe -t FIN.BUSINESS_LOCATION -i sde:oracle10g -u sde -p sde@gispub
sdetable -o alter_column -t FIN.BUSINESS_LOCATION -c OBJECTID -z float64 -i sde:oracle10g -u sde -p sde@gispub

topic Geocoding throws an Error ORA-01455 in Data Management Questions

Geocoding throws an Error ORA-01455