然后发现还原的sde库st_domain_methods编译失败
重新执行st_domain_methods,提示缺少某函数,于是找到这个函数,执行函数(下面是包体,包含了该函数,直接执行包体)
附上全包:
CREATE OR REPLACE Package st_relation_operators Authid current_user
/***********************************************************************
*
*n {st_Relation_Operators.sps} -- st_Geometry relation functions.
*
*:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
*
*p purpose:
* this pl/sql package specification defines relation operators
* to support the st_Geometry type.
*e
*:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
*
*x legalese:
*
* copyright 1992-2004 esri
*
* trade secrets: esri proprietary and confidential
* unpublished material - all rights reserved under the
* copyright laws of the united states.
*
* for additional information, contact:
* environmental systems research institute, inc.
* attn: contracts dept
* 380 new york street
* redlands, california, usa 92373
*
* email: contracts@esri.com
*
*e
*:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
*
*h history:
*
* kevin watt 12/02/04 original coding.
*e
***********************************************************************/
IS
c_package_release Constant pls_integer := 1011;
no_filter Constant pls_integer := 0;
equality_filter Constant pls_integer := 1;
disjoint_filter Constant pls_integer := 2;
inside_filter Constant pls_integer := 3;
-- st_Spatial_Relations must match isocomn.h st_Spatial_Operators enum.
st_intersects Constant pls_integer := 1;
st_within Constant pls_integer := 2;
st_overlaps Constant pls_integer := 3;
st_touches Constant pls_integer := 4;
st_contains Constant pls_integer := 5;
st_crosses Constant pls_integer := 6;
st_orderingequals Constant pls_integer := 7;
st_equals Constant pls_integer := 8;
st_disjoint Constant pls_integer := 9;
st_distance Constant pls_integer := 10;
st_relate Constant pls_integer := 11;
Function st_contains_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_within_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_intersects_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_overlaps_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_touches_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_crosses_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_orderingequals_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_equals_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_disjoint_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry)
Return number deterministic;
Function st_relate_f(shape1 SDE.st_geometry,shape2 SDE.st_geometry,matrix varchar2)
Return number deterministic;
Pragma Restrict_References (st_relation_operators,wnds,wnps);
End st_relation_operators;
/
## 再编译这个st_domain_methods成功,然后就可以继续配置arcsde了