以前没做过,下午同事问到一insert报错,才发现自己的浅薄,直接上SQL啦
insert into SDE_dlxd
(OBJECTID,
IDREF,
DOMAIN,
NAME,
CODE,
SHAPE.ENTITY,
SHAPE.NUMPTS,
SHAPE.MINX,
SHAPE.MINY,
SHAPE.MAXX,
SHAPE.MAXY,
SHAPE.MINZ,
SHAPE.MAXZ,
SHAPE.MINM,
SHAPE.MAXM,
SHAPE.AREA,
SHAPE.LEN,
SHAPE.SRID,
SHAPE.POINTS)
select k.OBJECTID,
k.IDREF,
k.DOMAIN,
k.NAME,
k.CODE,
k.SHAPE.ENTITY,
k.SHAPE.NUMPTS,
k.SHAPE.MINX,
k.SHAPE.MINY,
k.SHAPE.MAXX,
k.SHAPE.MAXY,
k.SHAPE.MINZ,
k.SHAPE.MAXZ,
k.SHAPE.MINM,
k.SHAPE.MAXM,
k.SHAPE.AREA,
k.SHAPE.LEN,
k.SHAPE.SRID,
k.SHAPE.POINTS
from linyi_电缆接头bk k
ORA-00904: "SHAPE"."POINTS": 标识符无效
create table SDE_dlxd
(
OBJECTID INTEGER not null,
IDREF NUMBER(18) not null,
DOMAIN NVARCHAR2(255),
NAME NVARCHAR2(255),
CODE NVARCHAR2(255),
SHAPE SDE.ST_GEOMETRY
);
CREATE OR REPLACE TYPE SDE.ST_GEOMETRY AUTHID CURRENT_USER AS OBJECT
--C_Type_Release 1007
(
ENTITY INTEGER,
NUMPTS INTEGER,
MINX FLOAT(64),
MINY FLOAT(64),
MAXX FLOAT(64),
MAXY FLOAT(64),
MINZ FLOAT(64),
MAXZ FLOAT(64),
MINM FLOAT(64),
MAXM FLOAT(64),
AREA FLOAT(64),
LEN FLOAT(64),
SRID INTEGER,
POINTS BLOB,
CONSTRUCTOR FUNCTION ST_GEOMETRY
(
GEOM_STR CLOB,
SRID NUMBER
) RETURN SELF AS RESULT DETERMINISTIC,
MEMBER FUNCTION ST_AREA RETURN NUMBER,
MEMBER FUNCTION ST_LEN RETURN NUMBER,
MEMBER FUNCTION ST_LENGTH RETURN NUMBER,
MEMBER FUNCTION ST_ENTITY RETURN NUMBER,
MEMBER FUNCTION ST_NUMPTS RETURN NUMBER,
MEMBER FUNCTION ST_MINX RETURN NUMBER,
MEMBER FUNCTION ST_MAXX RETURN NUMBER,
MEMBER FUNCTION ST_MINY RETURN NUMBER,
MEMBER FUNCTION ST_MAXY RETURN NUMBER,
MEMBER FUNCTION ST_MINM RETURN NUMBER,
MEMBER FUNCTION ST_MAXM RETURN NUMBER,
MEMBER FUNCTION ST_MINZ RETURN NUMBER,
MEMBER FUNCTION ST_MAXZ RETURN NUMBER,
MEMBER FUNCTION ST_SRID RETURN NUMBER,
STATIC FUNCTION GET_RELEASE RETURN NUMBER
)
NOT FINAL;
INSERT INTO SDE_dlxd
SELECT K.OBJECTID,
K.IDREF,
K.DOMAIN,
K.NAME,
K.CODE,
SDE.ST_GEOMETRY(K.SHAPE.ENTITY,
K.SHAPE.NUMPTS,
K.SHAPE.MINX,
K.SHAPE.MINY,
K.SHAPE.MAXX,
K.SHAPE.MAXY,
K.SHAPE.MINZ,
K.SHAPE.MAXZ,
K.SHAPE.MINM,
K.SHAPE.MAXM,
K.SHAPE.AREA,
K.SHAPE.LEN,
K.SHAPE.SRID,
K.SHAPE.POINTS)
FROM LINYI_dlxdBK K