Is This Content Helpful?
We're glad to know this article was helpful.
An Oracle OLE DB table that has a NUMBER (9) PRIMARY KEY or a NUMBER(9)UNIQUE NOT NULL column can support selections in ArcGIS.
If the OLE DB table does not have a suitable field and users wish to enable Select by Attribute or relate the table to other data sources, add a new field as outlined below.
This procedure is performed in SQLPlus while connected as the owner of the table.
ALTER TABLE MyData ADD (theIDCol NUMBER(9));
CREATE SEQUENCE MyGen START WITH 1;
This requires the CREATE SEQUENCE system privilege.
UPDATE MyData SET theIDCol = MyGen.NEXTVAL;
ALTER TABLE MyData MODIFY (theIDCol NOT NULL);
CREATE UNIQUE INDEX MyDataIDX ON MyData (theIDCol);
ALTER TABLE MyData ADD CONSTRAINT theIDCol_PK PRIMARY KEY(theIDCOL));