Original User: gstaats
Thanks for the quick response. I am using ArcSDE 9.3.1 running on Windows Server 2k8 64. DB is Oracle 11G R2 running on an AIX box.
I wanted to try something else... So I created a test table in oracle.
CREATE TABLE Test (
ObjectID NUMBER(10,0) unique not null,
NLF_ID VARCHAR2(14),
GEOMETRY MDSYS.SDO_GEOMETRY )
And then inserted 3 features
INSERT INTO TEST (objectid, NLF_ID, Geometry)
VALUES (1,
'Feature1',
SDO_GEOMETRY(
2001,
NULL,
SDO_POINT_TYPE(12, 3, NULL),
NULL,
NULL)
);
INSERT INTO TEST (objectid, NLF_ID, Geometry)
VALUES (2,
'Feature2',
SDO_GEOMETRY(
2001,
NULL,
SDO_POINT_TYPE(10, 16, NULL),
NULL,
NULL)
);
INSERT INTO TEST (objectid, NLF_ID, Geometry)
VALUES (3,
'Feature3',
SDO_GEOMETRY(
2001,
NULL,
SDO_POINT_TYPE(18, 19, NULL),
NULL,
NULL)
);
I tried to register this table with ArcSDE as well.. It would register, but again, I could not see the points created.
C:\Windows\system32>sdelayer -o register -l TEST,GEOMETRY -u user -p pass -P High -e p -t SDO_GEOMETRY -C OBJECTID,SDE -x -180,-90,1000