电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

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

来源:金蝶云社区作者:金蝶2024-09-165

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

如图,登录报错。 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 NOCO

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

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

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

已经是第一篇
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信