The ArcSDE(64 bit)'s bug: ORA01480 ?

Question

Oracle: 10.2.0.4, 64 bit
ArcSDE: 9.3.1, 64 bit
OS: Windows Server 2008, 64 bit

When I import vector datas into SDE Geodatabase, and the type of geometry field is ST_Geometry,
then the ORA01480 error appears.

I ask an esri stuff, he says that this is 64bit SDE' bug,  does the ArcGIS 10 have this bug?

huangJary · Answer

The proplem is the bug of ArcSDE 64bit, it appeared two years ago, but ESRI hasn't modified this bug up to now

szcszc · Answer

Is your database 10g or 11g, or did you have this problem with both databases?

I rarely use 'sdelayer' to create geometry columns. I wonder if the problem is
more with 'sdelayer' than the underlying SE_layer_create API call.

I'm also wondering if it has to do with the lack of coordinate reference information
(no "-G" and "-x" [or "-R"]). What happens if you define a proper coordref?

The 'sdelayer' command accepts a flag to register the rowid column during
'-o add' -- what happens if you skip the 'sdetable -o alter_reg' and just add
"-C objectid" to 'sdelayer -o add'?

The objectid column is required to be NOT NULL -- what happens if you
define it that way with 'sdetable -o create'?

- V

My Oracle Database is 11g, The proplem appears only if ArcSDE is 64bit

The error appears also when  I using ArcCatalog.

C:\Documents and Settings\hongwei.yu\sdetable -o create -t POI2 -d "OBJECTI
D integer NOT NULL,GLOBAL_ID integer(10),MESH_ID string(10),POI_ID integer(10),POI_TYPE s
tring(6),AD_CODE string(6),NAME string(160),ADDRESS string(160),IMPORTANCE small
int(3),PIC_ID string(24),TELEPHONE string(36),FAX string(36),POSTCODE string(6),
BIRTHDAY string(15),COORD_TYPE string(1),DISPLAY_CLASS string(2)" -i 5153 -s 172
.20.2.9 -u SDE -p ACCPTest

ArcSDE 9.3 for oracle 11g Build 1632 Thu Feb 26 12:05:37 2009
Attribute Administration Utility
------------------------------------------------------------
Successfully created table POI2

C:\Documents and Settings\hongwei.yu\sdelayer -o add -l POI2, shape -e p -k DEFAULTS -C objectid ,sde,1,-t ST_GEOMETRY -R 3 -i 5153 -s 172.20.2.9 -u SDE -p ACCPTest

ArcSDE 9.3 for oracle 11g Build 1632 Thu Feb 26 12:05:37 2009
Attribute Administration Utility
------------------------------------------------------------
Error: Underlying DBMS error <-51>.
Error: Cannot create Layer.
ORA-01480:

VinceAngelo · Answer

Is your database 10g or 11g, or did you have this problem with both databases?
 
I rarely use 'sdelayer' to create geometry columns. I wonder if the problem is
more with 'sdelayer' than the underlying SE_layer_create API call. 
 
I'm also wondering if it has to do with the lack of coordinate reference information
(no "-G" and "-x" [or "-R"]). What happens if you define a proper coordref?
 
The 'sdelayer' command accepts a flag to register the rowid column during
'-o add' -- what happens if you skip the 'sdetable -o alter_reg' and just add
"-C objectid" to 'sdelayer -o add'?
 
The objectid column is required to be NOT NULL -- what happens if you
define it that way with 'sdetable -o create'?
 
- V