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


数据表已经存在了,也没有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
恢复数据库时貌似不成功,登陆客户端报错
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



