恢复数据库时貌似不成功,登陆客户端报错
数据表已经存在了,也没有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"
把你恢复的过程或日志发出来看一下
恢复数据库时貌似不成功,登陆客户端报错
本文2024-09-16 23:03:47发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-52168.html