oracle11g 导入dmp

Question

我用命令行“imp sde/wqms@wqms fromuser=sde file=e:\es\wqms.dmp touser=sde” 账户、密码和路径均没错
我这个dmp里以前是有空间数据库的（Arcgis的），导入之后我仅能看到属性数据，空间数据则没有，有没有人知道是什么原因吗？

Answer 1

 增加一个log=your.log记录一下日志，查看一下有没有报错。

Answer 2

加个日志看 里面具体报什么错
log=e:\es\wqms.log

Answer 3

dmp文件是用哪个版本的clint导出的？  先确定是不是版本不兼容问题

Answer 4

exp sde/wqms@wqms file=e:\es\wqms.dmp

Answer 5

我一部分一部分贴哈
连接到: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options经由常规路径由 EXPORT:V11.01.00 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
IMP-00017: 由于 ORACLE 错误 4063, 以下语句失败:
 "BEGIN  "
 "sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','"
 "CURRENT_SCHEMA'), export_db_name=>'WQMS', inst_scn=>'5553710');"
 "COMMIT; END;"
IMP-00003: 遇到 ORACLE 错误 4063
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" 有错误
ORA-06508: PL/SQL: 无法找到正在调用 : "SYS.DBMS_LOGREP_UTIL" 的程序单元
ORA-06512: 在 "SYS.DBMS_LOGREP_IMP", line 282
ORA-06512: 在 line 2
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE LIBRARY "ST_SHAPELIB" UNTRUSTED AS 'C:\Program Files\ArcGIS\ArcSDE\o"
 "ra11gexe\bin\st_shapelib.dll'"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "SDENUMTAB" TIMESTAMP '2010-09-25:10:39:19' OID '547C4473D62642"
 "4A9612FA09CFC16518'   is table of number"
IMP-00061: 警告: 对象类型 "SDE"."SDENUMTAB" 已经以不同标识符存在
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "SP_GRID_INFO" TIMESTAMP '2010-09-25:10:39:25' OID 'E2B0FD51662"
 "4439C9ACCDA392BB85A05'   AS OBJECT (grid1 NUMBER, grid2 NUMBER, grid3 NUMBE"
 "R)"
IMP-00061: 警告: 对象类型 "SDE"."SP_GRID_INFO" 已经以不同标识符存在
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_FUNCS_ARRAY" TIMESTAMP '2010-09-25:10:39:25' OID 'DC8E77A12"
 "5CF4B528B6A76DFD5C5E6E7'   IS VARRAY(100) OF VARCHAR2(64)"
IMP-00061: 警告: 对象类型 "SDE"."ST_FUNCS_ARRAY" 已经以不同标识符存在
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_DOMAIN_STATS" TIMESTAMP '2010-09-25:10:39:34' OID '114318DD"
 "8E704811AD6A83C54EA2BF62'   Authid current_user AS object"
 "        --C_Type_Release 1001"
 "("
 "  curnum number,"
 "  STATIC FUNCTION odcigetinterfaces(ifclist  OUT sys.odciobjectlist)"
 "         RETURN NUMBER,"
 "  STATIC FUNCTION odcistatscollect(col       sys.odcicolinfo,"
 "                                   options   sys.ODCIStatsOptions,"
 "                                   rawstats  OUT raw,"
 "                                   env       sys.odcienv)"
 "         RETURN NUMBER,"
 "  STATIC FUNCTION odcistatsdelete(col       sys.odcicolinfo,"
 "                                  ia        sys.odciindexinfo,  "
 "                                  rawstats  OUT raw,"
 "                                  env       sys.odcienv)"
 "         RETURN NUMBER,"
 "  STATIC FUNCTION odcistatscollect(ia        sys.odciindexinfo,"
 "                                   options   sys.odcistatsoptions,"
 "                                   rawstats  OUT raw,"
 "                                   env       sys.odcienv)"
 "         RETURN NUMBER,"
 "  STATIC FUNCTION odcistatsdelete(ia        sys.odciindexinfo, "
 "                                  rawstats  OUT raw,"
 "                                  env       sys.odcienv) "
 "         RETURN NUMBER,"
 "  STATIC FUNCTION odcistatsselectivity(pred     sys.odcipredinfo,"
 "                                       sel      Out number, "
 "                                       args     sys.odciargdesclist,"
 "                                       strt     number,"
 "                                       stop     number,  "
 "                                       object1  SDE.st_geometry, "
 "                                       object2  SDE.st_geometry,"
 "                                       env      sys.odcienv)"
 "         Return number,"
 "  STATIC FUNCTION odcistatsselectivity(pred    sys.odcipredinfo,"
 "                                       sel     Out number, "
 "                                       args    sys.odciargdesclist,"
 "                                       strt    number,"
 "                                       stop    number, "
 "                                       object  SDE.st_geometry, "
 "                                       minx    number, "
 "                                       miny    number,"
 "                                       maxx    number,"
 "                                       maxy    number,"
 "                                       env     sys.odcienv) "
 "         Return number,"
 "  STATIC FUNCTION odcistatsselectivity(pred     sys.odcipredinfo,"
 "                                       sel      Out number, "
 "                                       args     sys.odciargdesclist,"
 "                                       strt     number,"
 "                                       stop     number, "
 "                                       object1  SDE.st_geometry,"
 "                                       object2  SDE.st_geometry,"
 "                                       matrix   varchar2, "
 "                                       env      sys.odcienv) "
 "         Return number,"
 "  STATIC FUNCTION odcistatsindexcost(ia    sys.odciindexinfo,"
 "                                     sel   number,"
 "                                     cost  Out sys.odcicost, "
 "                                     qi    sys.odciqueryinfo,"
 "                                     pred  sys.odcipredinfo,"
 "                                     args  sys.odciargdesclist,"
 "                                     strt  number,"
 "                                     stop  number,  "
 "                                     minx  number,"
 "                                     miny  number, "
 "                                     maxx  number, "
 "                                     maxy  number,"
 "                                     env   sys.odcienv)"
 "         Return number,"
 "  STATIC FUNCTION odcistatsindexcost(ia      sys.odciindexinfo,"
 "                                     sel     number,"
 "                                     cost    Out sys.odcicost, "
 "                                     qi      sys.odciqueryinfo,"
 "                                     pred    sys.odcipredinfo,"
 "                                     args    sys.odciargdesclist,"
 "                                     strt    number,"
 "                                     stop    number,  "
 "                                     object  SDE.st_geometry,"
 "                                     env     sys.odcienv) "
 "         Return number,"
 "  STATIC FUNCTION odcistatsindexcost(ia      sys.odciindexinfo,"
 "                                     sel     number,"
 "                                     cost    Out sys.odcicost, "
 "                                     qi      sys.odciqueryinfo,"
 "                                     pred    sys.odcipredinfo,"
 "                                     args    sys.odciargdesclist,"
 "                                     strt    number,"
 "                                     stop    number,  "
 "                                     object  SDE.st_geometry,"
 "                                     matrix  varchar2,"
 "                                     env     sys.odcienv) "
 "         Return number,"
 "         -- PRAGMA restrict_references(ODCIStatsIndexCost, WNDS, WNPS),"
 "  STATIC FUNCTION odcistatsfunctioncost(func     sys.odcifuncinfo,"
 "                                        cost     Out sys.odcicost, "
 "                                        args     sys.odciargdesclist,"
 "                                        object1  SDE.st_geometry,"
 "                                        object2  SDE.st_geometry,"
 "                                        env      sys.odcienv)"
 "         Return number,"
 "  STATIC FUNCTION odcistatsfunctioncost(func    sys.odcifuncinfo,"
 "                                        cost    Out sys.odcicost, "
 "                                        args    sys.odciargdesclist,"
 "                                        object  SDE.st_geometry, "
 "                                        minx    number, "
 "                                        miny    number, "
 "                                        maxx    number, "
 "                                        maxy    number,"
 "                                        env     sys.odcienv)"
 "         Return number,"
 "  STATIC FUNCTION odcistatsfunctioncost(func     sys.odcifuncinfo,"
 "                                        cost     Out sys.odcicost, "
 "                                        args     sys.odciargdesclist,"
 "                                        object1  SDE.st_geometry,"
 "                                        object2  SDE.st_geometry,"
 "                                        matrix   varchar2,"
 "                                        env      sys.odcienv)"
 "         Return number,"
 "  STATIC FUNCTION get_release"
 "         RETURN NUMBER"
 ");"

Answer 6

IMP-00061: 警告: 对象类型 "SDE"."ST_DOMAIN_STATS" 已经以不同标识符存在
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_GEOMETRY" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1D8"
 "4E13B35784E171530100'   "
 "                                                Authid current_user  AS obj"
 "ect"
 "        --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;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_POINT" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1D84E1"
 "3B35784E171530101'       "
 "                                                       under SDE.st_geometr"
 "y "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_point(geom_str varchar2,srid number) Return self "
 "AS result deterministic,"
 "  constructor Function st_point(pt_x number,pt_y number,srid number) Return"
 " self AS result deterministic,"
 "  constructor Function st_point(pt_x number,pt_y number,pt_z number,srid nu"
 "mber) Return self AS result deterministic,"
 "  constructor Function st_point(pt_x number,pt_y number,pt_z number,measure"
 " number,srid number) Return self AS result deterministic,"
 "  static Function get_release Return number"
 ") NOT final;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_CURVE" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1D84E1"
 "3B35784E171530102'       "
 "                                                       under SDE.st_geometr"
 "y  "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_curve(geom_str clob,srid number) Return self AS r"
 "esult deterministic,"
 "  static Function get_release Return number"
 ") NOT final;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_SURFACE" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1D84"
 "E13B35784E171530104'       "
 "                                                       under SDE.st_geometr"
 "y "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_surface(geom_str clob,srid number) Return self AS"
 " result deterministic,"
 "  static Function get_release Return number"
 ") NOT final;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_GEOMCOLLECTION" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA"
 "8DD1D84E13B35784E171530106'       "
 "                                                        under SDE.st_geomet"
 "ry "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_geomcollection(geom_str varchar2,srid number) Ret"
 "urn self AS result deterministic,"
 "  static Function get_release Return number"
 ") NOT final;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_LINESTRING" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1"
 "D84E13B35784E171530103'       "
 "                                                       under SDE.st_curve "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_linestring(geom_str clob,srid number) Return self"
 " AS result deterministic,"
 "  static Function get_release Return number"
 ") NOT final;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_POLYGON" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1D84"
 "E13B35784E171530105'       "
 "                                                        under SDE.st_surfac"
 "e "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_polygon(geom_str clob,srid number) Return self AS"
 " result deterministic,"
 "  static Function get_release Return number"
 ") NOT final;"
IMP-00015: 由于对象已存在, 下列语句失败: 
 "CREATE TYPE "ST_MULTIPOINT" TIMESTAMP '2010-09-25:10:39:34' OID 'A618FA8DD1"
 "D84E13B35784E171530107'       "
 "                                                        under SDE.st_geomco"
 "llection "
 "        --C_Type_Release 1001"
 "("
 "  constructor Function st_multipoint(geom_str clob,srid number) Return self"
 " AS result deterministic,"
 "  static Function get_release Return number"
 ");"

Answer 7

我记得空间数据库是要到用户MDSYS的，你看看这个用户是不是没有开启或者没有创建，那样的话，导出导入可能都有些问题。所有的空间属性都与这个用户有关系。

Answer 8

“imp sde/wqms@wqms fromuser=sde file=e:\es\wqms.dmp touser=sde”
这样试试imp sde/wqms@wqms fromuser=sde   touser=sde  file=e:\es\wqms.dmp  ignore=y

Answer 9

空间数据是成功导入了，不过我用ArcMap还是打不开，提示gsrvr.exe内存错误，然后又弹出NetWork I/O error， 这是什么原因呢

Answer 10

ArcMap 是你应用上的问题，这个帮不了了

Answer 11

问题解决了，我重新配置了下ArcSDE就可以了。