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
