ArcCatalog | Oracle | 备注 |
OBJECTID | INTEGER | |
TEXT | NVARCHAR2(50) | |
Short Internet | NUMBER(5) | |
Short Internet | NUMBER(4) | Precision = 4 |
Long Internet | INTEGER | |
Float | NUMBER(38,8) | Precision = 0,Scale=0 |
Float | NUMBER(4,3) | Precision = 4,Scale=3 |
Double | NUMBER(38,8) | Precision = 0,Scale=0 |
Double | NUMBER(8,3) | Precision = 8,Scale=3 |
Date | DATE | |
Blob | BLOB | |
Guid | CHAR(38) | |
SHAPE | INTEGER | |
Raster | INTEGER |
注意:
1、PGDB中TEXT类型由于受到Acess数据库限制,最大长度为255。超过该长度,Access中自动转为备注类型。如果导入到Oracle中,对应类型为NCLOB。