恢复数据库时貌似不成功,登陆客户端报错

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

恢复数据库时貌似不成功,登陆客户端报错

如图,登录报错。 EAS版本是7.03,恢复ORACLE数据库的时候没见提示成功。老是卡住在那个界面。如何恢复数据成功以致可以成功登录客户端?


数据表已经存在了,也没有schema,删除当前schema或重新指定,下面参考
https://vip.kingdee.com/article/43437086465392664

我就截一部分吧。太长了。

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

经由常规路径由 EXPORT:V10.02.01 创建的导出文件

警告: 这些对象由 YFMY3 导出, 而不是当前用户

已经完成 ZHS16GBK 字符集和 UTF8 NCHAR 字符集中的导入
导入服务器使用 UTF8 字符集 (可能的字符集转换)
. 正在将 YFMY3 的对象导入到 TEST10
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_DEPRECIATION" ("FNUMBER" NVARCHAR2(80), "FSIMPLENAME" "
"NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABLE, "FCREATORID" VARCHAR2(44"
"), "FCREATETIME" TIMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPD"
"ATETIME" TIMESTAMP (6), "FCONTROLUNITID" VARCHAR2(44), "CFMONTHS" NUMBER(10"
", 0), "FNAME_L1" NVARCHAR2(255), "FNAME_L2" NVARCHAR2(255), "FNAME_L3" NVAR"
"CHAR2(255), "FDESCRIPTION_L1" NVARCHAR2(255), "FDESCRIPTION_L2" NVARCHAR2(2"
"55), "FDESCRIPTION_L3" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
"XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_EGGANDGEN" ("FCREATORID" VARCHAR2(44), "FCREATETIME" T"
"IMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP"
" (6), "FCONTROLUNITID" VARCHAR2(44), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TI"
"MESTAMP (6), "FHANDLERID" VARCHAR2(44), "FDESCRIPTION" NVARCHAR2(80), "FHAS"
"EFFECTED" NUMBER(10, 0), "FAUDITORID" VARCHAR2(44), "FSOURCEBILLID" NVARCHA"
"R2(80), "FSOURCEFUNCTION" NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABLE"
", "FFIVOUCHERED" NUMBER(10, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS "
"255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT"
") LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_EGGANDGENENTRY" ("FSEQ" NUMBER(10, 0), "FID" VARCHAR2("
"44) NOT NULL ENABLE, "FPARENTID" VARCHAR2(44), "CFEGGID" VARCHAR2(44), "CFG"
"ENETICSID" VARCHAR2(44)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENANDRES" ("FCREATORID" VARCHAR2(44), "FCREATETIME" T"
"IMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP"
" (6), "FCONTROLUNITID" VARCHAR2(44), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TI"
"MESTAMP (6), "FHANDLERID" VARCHAR2(44), "FDESCRIPTION" NVARCHAR2(80), "FHAS"
"EFFECTED" NUMBER(10, 0), "FAUDITORID" VARCHAR2(44), "FSOURCEBILLID" NVARCHA"
"R2(80), "FSOURCEFUNCTION" NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABLE"
", "FFIVOUCHERED" NUMBER(10, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS "
"255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT"
") LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENANDRESENTRY" ("FSEQ" NUMBER(10, 0), "FID" VARCHAR2("
"44) NOT NULL ENABLE, "FPARENTID" VARCHAR2(44), "CFGENGICID" VARCHAR2(44), ""
"CFPRENT" NUMBER(28, 10)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STO"
"RAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENGRPNUMSET" ("FNUMBER" NVARCHAR2(80), "FSIMPLENAME" "
"NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABLE, "FCREATORID" VARCHAR2(44"
"), "FCREATETIME" TIMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPD"
"ATETIME" TIMESTAMP (6), "FCONTROLUNITID" VARCHAR2(44), "CFFEEDNUM" NVARCHAR"
"2(100), "CFCHICKENNUM" NVARCHAR2(100), "CFSALENUM" NVARCHAR2(100), "CFBIGNU"
"M" NVARCHAR2(100), "CFSALEEGGNUM" NVARCHAR2(100), "CFEGGNUM" NVARCHAR2(100)"
", "CFVACCINENUM" NVARCHAR2(100), "CFDRUGSNUM" NVARCHAR2(100), "CFRAWNUM" NV"
"ARCHAR2(100), "CFPACKAGNUM" NVARCHAR2(100), "CFMANURENUM" NVARCHAR2(100), ""
"CFFUEL" NVARCHAR2(100), "CFBREEDERSNUM" NVARCHAR2(100), "CFOTHER" NVARCHAR2"
"(100), "CFCHICKENFEEDNUM" NVARCHAR2(100), "CFSALEFEEDNUM" NVARCHAR2(100), ""
"CFOUTSALEFEEDNUM" NVARCHAR2(100), "CFSALECHICKEN" NVARCHAR2(100), "FNAME_L1"
"" NVARCHAR2(255), "FNAME_L2" NVARCHAR2(255), "FNAME_L3" NVARCHAR2(255), "FD"
"ESCRIPTION_L1" NVARCHAR2(255), "FDESCRIPTION_L2" NVARCHAR2(255), "FDESCRIPT"
"ION_L3" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENTYPE" ("FCREATORID" VARCHAR2(44), "FCREATETIME" TIM"
"ESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP ("
"6), "FCONTROLUNITID" VARCHAR2(44), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TIME"
"STAMP (6), "FHANDLERID" VARCHAR2(44), "FDESCRIPTION" NVARCHAR2(80), "FHASEF"
"FECTED" NUMBER(10, 0), "FAUDITORID" VARCHAR2(44), "FSOURCEBILLID" NVARCHAR2"
"(80), "FSOURCEFUNCTION" NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABLE, "
""FFIVOUCHERED" NUMBER(10, 0), "CFNAME" NVARCHAR2(100)) PCTFREE 10 PCTUSED "
"40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
"S 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRE"
"SS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENTYPEENTRY" ("FSEQ" NUMBER(10, 0), "FID" VARCHAR2(44"
") NOT NULL ENABLE, "FPARENTID" VARCHAR2(44), "CFGENGICID" VARCHAR2(44)) PC"
"TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS"
" 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENTYPEVAC" ("FCREATORID" VARCHAR2(44), "FCREATETIME" "
"TIMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAM"
"P (6), "FCONTROLUNITID" VARCHAR2(44), "FNUMBER" NVARCHAR2(80), "FBIZDATE" T"
"IMESTAMP (6), "FHANDLERID" VARCHAR2(44), "FDESCRIPTION" NVARCHAR2(80), "FHA"
"SEFFECTED" NUMBER(10, 0), "FAUDITORID" VARCHAR2(44), "FSOURCEBILLID" NVARCH"
"AR2(80), "FSOURCEFUNCTION" NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABL"
"E, "FFIVOUCHERED" NUMBER(10, 0), "CFNAME" NVARCHAR2(100)) PCTFREE 10 PCTUS"
"ED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GR"
"OUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOM"
"PRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_GENTYPEVACENTRY" ("FSEQ" NUMBER(10, 0), "FID" VARCHAR2"
"(44) NOT NULL ENABLE, "FPARENTID" VARCHAR2(44), "CFGENGICID" VARCHAR2(44)) "
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI"
"STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_INITIALIZATION" ("FCREATORID" VARCHAR2(44), "FCREATETI"
"ME" TIMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPDATETIME" TIME"
"STAMP (6), "FCONTROLUNITID" VARCHAR2(44), "FNUMBER" NVARCHAR2(80), "FBIZDAT"
"E" TIMESTAMP (6), "FHANDLERID" VARCHAR2(44), "FDESCRIPTION" NVARCHAR2(80), "
""FHASEFFECTED" NUMBER(10, 0), "FAUDITORID" VARCHAR2(44), "FSOURCEBILLID" NV"
"ARCHAR2(80), "FSOURCEFUNCTION" NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL E"
"NABLE, "FFIVOUCHERED" NUMBER(10, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
"RANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DE"
"FAULT) LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BAS_INITIALIZATIONENTRY" ("FSEQ" NUMBER(10, 0), "FID" VARC"
"HAR2(44) NOT NULL ENABLE, "FPARENTID" VARCHAR2(44), "CFSTORAGEORGUNITID" VA"
"RCHAR2(44), "CFDATE" TIMESTAMP (6)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR"
"ANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
"AULT) LOGGING NOCOMPRESS"
IMP-00015: 由于对象已存在, 下列语句失败:
"CREATE TABLE "CT_BRD_ACCEPTANCE" ("FCREATORID" VARCHAR2(44), "FCREATETIME" "
"TIMESTAMP (6), "FLASTUPDATEUSERID" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAM"
"P (6), "FCONTROLUNITID" VARCHAR2(44), "FNUMBER" NVARCHAR2(80), "FBIZDATE" T"
"IMESTAMP (6), "FHANDLERID" VARCHAR2(44), "FDESCRIPTION" NVARCHAR2(80), "FHA"
"SEFFECTED" NUMBER(10, 0), "FAUDITORID" VARCHAR2(44), "FSOURCEBILLID" NVARCH"
"AR2(80), "FSOURCEFUNCTION" NVARCHAR2(80), "FID" VARCHAR2(44) NOT NULL ENABL"
"E, "FFIVOUCHERED" NUMBER(10, 0), "CFSTORAGEORGUNITID" VARCHAR2(44), "CFCHEC"
"KDATE" TIMESTAMP (6), "CFAUDITDATE" TIMESTAMP (6), "CFAUDITUSERID" VARCHAR2"
"(44), "CFIFAUDITING" NUMBER(10, 0), "CFFEEDRECID" VARCHAR2(44), "CFCHECKER""
" NVARCHAR2(100), "CFSUM" NVARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 "
"MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
"L DEFAULT) LOGGING NOCOMPRESS"


把你恢复的过程或日志发出来看一下

恢复数据库时貌似不成功,登陆客户端报错

如图,登录报错。 EAS版本是7.03,恢复ORACLE数据库的时候没见提示成功。老是卡住在那个界面。如何恢复数据成功以致可以成功登录客户端?...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息