我在恢复数据库的时候 恢复一阵子以后 就提示以下错误IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_OTHEREXPENSEBILL" ("FID" VARCHAR2(44) NOT NULL ENABLE, ""
"FCREATORID" VARCHAR2(44), "FCREATETIME" TIMESTAMP (6), "FLASTUPDATEUSERID" "
"VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP (6), "FCONTROLUNITID" VARCHAR2(44"
"), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TIMESTAMP (6), "FHANDLERID" VARCHAR2"
"(44), "FDESCRIPTION" NVARCHAR2(400), "FHASEFFECTED" NUMBER(10, 0), "FAUDITO"
"RID" VARCHAR2(44), "FSOURCEBILLID" NVARCHAR2(80), "FSOURCEFUNCTION" NVARCHA"
"R2(80), "FNAME" NVARCHAR2(80), "FAPPLIERID" VARCHAR2(44), "FPOSITIONID" VAR"
"CHAR2(44), "FTEL" NVARCHAR2(50), "FORGUNITID" VARCHAR2(44), "FBIZREQDATE" T"
"IMESTAMP (6), "FCAUSE" NVARCHAR2(400), "FPRIOR" NUMBER(10, 0), "FSTATE" NUM"
"BER(10, 0), "FAUDITDATE" TIMESTAMP (6), "FBILLDATE" TIMESTAMP (6), "FBILLER"
"ID" VARCHAR2(44), "FBILLTYPECODE" NUMBER(10, 0), "FCOSTEDDEPTID" VARCHAR2(4"
"4), "FCOMPANYID" VARCHAR2(44), "FSUPPORTEDOBJID" VARCHAR2(44), "FCURRENCYID"
"" VARCHAR2(44), "FEXPENSETYPEID" VARCHAR2(44), "FAMOUNT" NUMBER(28, 10), "F"
"AMOUNTAPPROVED" NUMBER(28, 10), "FAMOUNTSENDEDBACK" NUMBER(28, 10), "FAMOUN"
"TCOPY" NUMBER(28, 10), "FAMOUNTUSED" NUMBER(28, 10), "FAMOUNTBALANCE" NUMBE"
"R(28, 10), "FAMOUNTCONTROLTYPE" NUMBER(10, 0), "FAPPLIERCOMPANYID" VARCHAR2"
"(44), "FOPERATIONTYPEID" VARCHAR2(44), "FPAYMODEID" VARCHAR2(44), "FBUDGETD"
"O" NUMBER(28, 10), "FSOURCEBILLTYPE" NUMBER(10, 0), "FSUPPLIERID" VARCHAR2("
"44), "FCONTRACTNUM" NVARCHAR2(100)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR"
"ANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
"AULT) LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_OTHEREXPENSEBILLENTRY" ("FID" VARCHAR2(44) NOT NULL ENAB"
"LE, "FSEQ" NUMBER(10, 0), "FNAME" NVARCHAR2(80), "FPURPOSE" NVARCHAR2(200),"
" "FHAPPENTIME" TIMESTAMP (6), "FAMOUNT" NUMBER(28, 10), "FCOMMENT" NVARCHAR"
"2(200), "FBILLID" VARCHAR2(44), "FPARTICIPANTS" NVARCHAR2(80), "FEXPENSETYP"
"EID" VARCHAR2(44), "FAMOUNTAPPROVED" NUMBER(28, 10), "FBUDGETAMOUNT" NUMBER"
"(28, 10), "FBUDGETDO" NUMBER(28, 10), "FAMOUNTBALANCE" NUMBER(28, 10), "FAM"
"OUNTUSED" NUMBER(28, 10), "FSOURCEAMOUNTBALANCE" NUMBER(28, 10), "FBUDGETUS"
"ED" NUMBER(28, 10), "FCOSTOBJECTID" VARCHAR2(44)) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 B"
"UFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
. . 正在导入表 "T_BC_OTHEREXPENSEBILLWK"导入了 0 行
. . 正在导入表 "T_BC_OTHEREXPENSEBILLWKENTRY"导入了 0 行
. . 正在导入表 "T_BC_SUMCONTROL"导入了 0 行
. . 正在导入表 "T_BC_SUMCONTROLENTRY"导入了 0 行
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_TRAVELACCOUNTBILL" ("FID" VARCHAR2(44) NOT NULL ENABLE, "
""FCREATORID" VARCHAR2(44), "FCREATETIME" TIMESTAMP (6), "FLASTUPDATEUSERID""
" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP (6), "FCONTROLUNITID" VARCHAR2(4"
"4), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TIMESTAMP (6), "FHANDLERID" VARCHAR"
"2(44), "FDESCRIPTION" NVARCHAR2(400), "FHASEFFECTED" NUMBER(10, 0), "FAUDIT"
"ORID" VARCHAR2(44), "FSOURCEBILLID" NVARCHAR2(80), "FSOURCEFUNCTION" NVARCH"
"AR2(80), "FNAME" NVARCHAR2(80), "FAPPLIERID" VARCHAR2(44), "FPOSITIONID" VA"
"RCHAR2(44), "FTEL" NVARCHAR2(50), "FORGUNITID" VARCHAR2(44), "FBIZREQDATE" "
"TIMESTAMP (6), "FCAUSE" NVARCHAR2(400), "FPRIOR" NUMBER(10, 0), "FSTATE" NU"
"MBER(10, 0), "FAUDITDATE" TIMESTAMP (6), "FBILLDATE" TIMESTAMP (6), "FBILLE"
"RID" VARCHAR2(44), "FBILLTYPECODE" NUMBER(10, 0), "FCOSTEDDEPTID" VARCHAR2("
"44), "FCOMPANYID" VARCHAR2(44), "FSUPPORTEDOBJID" VARCHAR2(44), "FCURRENCYI"
"D" VARCHAR2(44), "FEXPENSETYPEID" VARCHAR2(44), "FAMOUNT" NUMBER(28, 10), ""
"FBUDGETAMOUNT" NUMBER(28, 10), "FBUDGETBALANCE" NUMBER(28, 10), "FAMOUNTSEN"
"DEDBACK" NUMBER(28, 10), "FAMOUNTAPPROVED" NUMBER(28, 10), "FAMOUNTSTRIKED""
" NUMBER(28, 10), "FAMOUNTENCASHED" NUMBER(28, 10), "FAMOUNTREFUNDED" NUMBER"
"(28, 10), "FACCOUNTCREDITEDID" VARCHAR2(44), "FACCOUNTDEBITEDID" VARCHAR2(4"
"4), "FPAYMENT" VARCHAR2(44), "FACCESSORYCOUNT" NUMBER(10, 0), "FAMOUNTCOPY""
" NUMBER(28, 10), "FFIVOUCHERED" NUMBER(10, 0), "FAMOUNTBALANCE" NUMBER(28, "
"10), "FAMOUNTUSED" NUMBER(28, 10), "FAMOUNTCONTROLTYPE" NUMBER(10, 0), "FAP"
"PLIERCOMPANYID" VARCHAR2(44), "FOPERATIONTYPEID" VARCHAR2(44), "FBUDGETDO" "
"NUMBER(28, 10), "FSOURCEBILLTYPE" NUMBER(10, 0), "FACTIONFLAG" VARCHAR2(20)"
", "FCONTRACTNUM" NVARCHAR2(100), "FSUPPLIERID" VARCHAR2(44)) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_TRAVELACCOUNTBILLENTRY" ("FID" VARCHAR2(44) NOT NULL ENA"
"BLE, "FSEQ" NUMBER(10, 0), "FFROM" NVARCHAR2(80), "FTO" NVARCHAR2(80), "FST"
"ARTDATE" TIMESTAMP (6), "FENDDATE" TIMESTAMP (6), "FVEHICLE" NUMBER(10, 0),"
" "FTAXIEXPENSE" NUMBER(28, 10), "FBUSSESEXPENSE" NUMBER(28, 10), "FHOTELEXP"
"ENSE" NUMBER(28, 10), "FOTHEREXPENSE" NUMBER(28, 10), "FAMOUNT" NUMBER(28, "
"10), "FBILLID" VARCHAR2(44), "FEVENTIONSUBSIDY" NUMBER(28, 10), "FEXPENSETY"
"PEID" VARCHAR2(44), "FAMOUNTAPPROVED" NUMBER(28, 10), "FBUDGETAMOUNT" NUMBE"
"R(28, 10), "FBUDGETDO" NUMBER(28, 10), "FAMOUNTBALANCE" NUMBER(28, 10), "FA"
"MOUNTUSED" NUMBER(28, 10), "FCOMPANYID" VARCHAR2(44), "FOPERATIONTYPEID" VA"
"RCHAR2(44), "FCOSTCENTERID" VARCHAR2(44), "FSOURCEAMOUNTBALANCE" NUMBER(28,"
" 10), "FBUDGETUSED" NUMBER(28, 10), "FRECEIVESTATE" NUMBER(10, 0), "FPAYSTA"
"TE" NUMBER(10, 0), "FCOSTOBJECTID" VARCHAR2(44), "FHAPPENTIME" TIMESTAMP (6"
")) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FRE"
"ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGG"
"ING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
由于小弟刚接触不久,请大虾们多帮忙,什么原因呢?多些大家了~
"CREATE TABLE "T_BC_OTHEREXPENSEBILL" ("FID" VARCHAR2(44) NOT NULL ENABLE, ""
"FCREATORID" VARCHAR2(44), "FCREATETIME" TIMESTAMP (6), "FLASTUPDATEUSERID" "
"VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP (6), "FCONTROLUNITID" VARCHAR2(44"
"), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TIMESTAMP (6), "FHANDLERID" VARCHAR2"
"(44), "FDESCRIPTION" NVARCHAR2(400), "FHASEFFECTED" NUMBER(10, 0), "FAUDITO"
"RID" VARCHAR2(44), "FSOURCEBILLID" NVARCHAR2(80), "FSOURCEFUNCTION" NVARCHA"
"R2(80), "FNAME" NVARCHAR2(80), "FAPPLIERID" VARCHAR2(44), "FPOSITIONID" VAR"
"CHAR2(44), "FTEL" NVARCHAR2(50), "FORGUNITID" VARCHAR2(44), "FBIZREQDATE" T"
"IMESTAMP (6), "FCAUSE" NVARCHAR2(400), "FPRIOR" NUMBER(10, 0), "FSTATE" NUM"
"BER(10, 0), "FAUDITDATE" TIMESTAMP (6), "FBILLDATE" TIMESTAMP (6), "FBILLER"
"ID" VARCHAR2(44), "FBILLTYPECODE" NUMBER(10, 0), "FCOSTEDDEPTID" VARCHAR2(4"
"4), "FCOMPANYID" VARCHAR2(44), "FSUPPORTEDOBJID" VARCHAR2(44), "FCURRENCYID"
"" VARCHAR2(44), "FEXPENSETYPEID" VARCHAR2(44), "FAMOUNT" NUMBER(28, 10), "F"
"AMOUNTAPPROVED" NUMBER(28, 10), "FAMOUNTSENDEDBACK" NUMBER(28, 10), "FAMOUN"
"TCOPY" NUMBER(28, 10), "FAMOUNTUSED" NUMBER(28, 10), "FAMOUNTBALANCE" NUMBE"
"R(28, 10), "FAMOUNTCONTROLTYPE" NUMBER(10, 0), "FAPPLIERCOMPANYID" VARCHAR2"
"(44), "FOPERATIONTYPEID" VARCHAR2(44), "FPAYMODEID" VARCHAR2(44), "FBUDGETD"
"O" NUMBER(28, 10), "FSOURCEBILLTYPE" NUMBER(10, 0), "FSUPPLIERID" VARCHAR2("
"44), "FCONTRACTNUM" NVARCHAR2(100)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR"
"ANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
"AULT) LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_OTHEREXPENSEBILLENTRY" ("FID" VARCHAR2(44) NOT NULL ENAB"
"LE, "FSEQ" NUMBER(10, 0), "FNAME" NVARCHAR2(80), "FPURPOSE" NVARCHAR2(200),"
" "FHAPPENTIME" TIMESTAMP (6), "FAMOUNT" NUMBER(28, 10), "FCOMMENT" NVARCHAR"
"2(200), "FBILLID" VARCHAR2(44), "FPARTICIPANTS" NVARCHAR2(80), "FEXPENSETYP"
"EID" VARCHAR2(44), "FAMOUNTAPPROVED" NUMBER(28, 10), "FBUDGETAMOUNT" NUMBER"
"(28, 10), "FBUDGETDO" NUMBER(28, 10), "FAMOUNTBALANCE" NUMBER(28, 10), "FAM"
"OUNTUSED" NUMBER(28, 10), "FSOURCEAMOUNTBALANCE" NUMBER(28, 10), "FBUDGETUS"
"ED" NUMBER(28, 10), "FCOSTOBJECTID" VARCHAR2(44)) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 B"
"UFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
. . 正在导入表 "T_BC_OTHEREXPENSEBILLWK"导入了 0 行
. . 正在导入表 "T_BC_OTHEREXPENSEBILLWKENTRY"导入了 0 行
. . 正在导入表 "T_BC_SUMCONTROL"导入了 0 行
. . 正在导入表 "T_BC_SUMCONTROLENTRY"导入了 0 行
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_TRAVELACCOUNTBILL" ("FID" VARCHAR2(44) NOT NULL ENABLE, "
""FCREATORID" VARCHAR2(44), "FCREATETIME" TIMESTAMP (6), "FLASTUPDATEUSERID""
" VARCHAR2(44), "FLASTUPDATETIME" TIMESTAMP (6), "FCONTROLUNITID" VARCHAR2(4"
"4), "FNUMBER" NVARCHAR2(80), "FBIZDATE" TIMESTAMP (6), "FHANDLERID" VARCHAR"
"2(44), "FDESCRIPTION" NVARCHAR2(400), "FHASEFFECTED" NUMBER(10, 0), "FAUDIT"
"ORID" VARCHAR2(44), "FSOURCEBILLID" NVARCHAR2(80), "FSOURCEFUNCTION" NVARCH"
"AR2(80), "FNAME" NVARCHAR2(80), "FAPPLIERID" VARCHAR2(44), "FPOSITIONID" VA"
"RCHAR2(44), "FTEL" NVARCHAR2(50), "FORGUNITID" VARCHAR2(44), "FBIZREQDATE" "
"TIMESTAMP (6), "FCAUSE" NVARCHAR2(400), "FPRIOR" NUMBER(10, 0), "FSTATE" NU"
"MBER(10, 0), "FAUDITDATE" TIMESTAMP (6), "FBILLDATE" TIMESTAMP (6), "FBILLE"
"RID" VARCHAR2(44), "FBILLTYPECODE" NUMBER(10, 0), "FCOSTEDDEPTID" VARCHAR2("
"44), "FCOMPANYID" VARCHAR2(44), "FSUPPORTEDOBJID" VARCHAR2(44), "FCURRENCYI"
"D" VARCHAR2(44), "FEXPENSETYPEID" VARCHAR2(44), "FAMOUNT" NUMBER(28, 10), ""
"FBUDGETAMOUNT" NUMBER(28, 10), "FBUDGETBALANCE" NUMBER(28, 10), "FAMOUNTSEN"
"DEDBACK" NUMBER(28, 10), "FAMOUNTAPPROVED" NUMBER(28, 10), "FAMOUNTSTRIKED""
" NUMBER(28, 10), "FAMOUNTENCASHED" NUMBER(28, 10), "FAMOUNTREFUNDED" NUMBER"
"(28, 10), "FACCOUNTCREDITEDID" VARCHAR2(44), "FACCOUNTDEBITEDID" VARCHAR2(4"
"4), "FPAYMENT" VARCHAR2(44), "FACCESSORYCOUNT" NUMBER(10, 0), "FAMOUNTCOPY""
" NUMBER(28, 10), "FFIVOUCHERED" NUMBER(10, 0), "FAMOUNTBALANCE" NUMBER(28, "
"10), "FAMOUNTUSED" NUMBER(28, 10), "FAMOUNTCONTROLTYPE" NUMBER(10, 0), "FAP"
"PLIERCOMPANYID" VARCHAR2(44), "FOPERATIONTYPEID" VARCHAR2(44), "FBUDGETDO" "
"NUMBER(28, 10), "FSOURCEBILLTYPE" NUMBER(10, 0), "FACTIONFLAG" VARCHAR2(20)"
", "FCONTRACTNUM" NVARCHAR2(100), "FSUPPLIERID" VARCHAR2(44)) PCTFREE 10 PC"
"TUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:
"CREATE TABLE "T_BC_TRAVELACCOUNTBILLENTRY" ("FID" VARCHAR2(44) NOT NULL ENA"
"BLE, "FSEQ" NUMBER(10, 0), "FFROM" NVARCHAR2(80), "FTO" NVARCHAR2(80), "FST"
"ARTDATE" TIMESTAMP (6), "FENDDATE" TIMESTAMP (6), "FVEHICLE" NUMBER(10, 0),"
" "FTAXIEXPENSE" NUMBER(28, 10), "FBUSSESEXPENSE" NUMBER(28, 10), "FHOTELEXP"
"ENSE" NUMBER(28, 10), "FOTHEREXPENSE" NUMBER(28, 10), "FAMOUNT" NUMBER(28, "
"10), "FBILLID" VARCHAR2(44), "FEVENTIONSUBSIDY" NUMBER(28, 10), "FEXPENSETY"
"PEID" VARCHAR2(44), "FAMOUNTAPPROVED" NUMBER(28, 10), "FBUDGETAMOUNT" NUMBE"
"R(28, 10), "FBUDGETDO" NUMBER(28, 10), "FAMOUNTBALANCE" NUMBER(28, 10), "FA"
"MOUNTUSED" NUMBER(28, 10), "FCOMPANYID" VARCHAR2(44), "FOPERATIONTYPEID" VA"
"RCHAR2(44), "FCOSTCENTERID" VARCHAR2(44), "FSOURCEAMOUNTBALANCE" NUMBER(28,"
" 10), "FBUDGETUSED" NUMBER(28, 10), "FRECEIVESTATE" NUMBER(10, 0), "FPAYSTA"
"TE" NUMBER(10, 0), "FCOSTOBJECTID" VARCHAR2(44), "FHAPPENTIME" TIMESTAMP (6"
")) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FRE"
"ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGG"
"ING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 959
ORA-00959: 表空间 'EAS_D_HJ_STANDARD' 不存在
由于小弟刚接触不久,请大虾们多帮忙,什么原因呢?多些大家了~
解决方案 »
- 安装weblogic问题,求助!!!
- 相同的程序,使用ORACLE做数据库,比使用SQL SERVER 2008在性能上有提升吗?
- 关于group by按某种格式显示
- CBO 基于成本的优化器
- about tablespace 控制
- apps是什么特殊的东西么,为什么别人有的也用apps登陆sql*plus?
- 关于在存储过程中删除表的数据?
- Oracle 中如何更好地使用help?怎幺找不到类似windows 和borland 的help的索引?比如我想查 show 的用法,我该怎幺查?
- 看看oracle如何将这个变量添加到数据库中
- 高手们:能否给我推荐一本关于VC6.0+Oracle 数据库开发方面的书?谢谢!!
- 求取得表中的所有字段,并进行补位的存储过程
- SQL查询
1. 创建表空间 EAS_D_HJ_STANDARD
2. revoke unlimited tablespace from user_name; 收回unlimited tablespace 权限之后重新导入
EAS_T_HJ_STANDARD
导入数据的时候提示EAS_D_HJEAS59_STANDARD表空间不存在后来表空间 临时表空间删掉以后再次导入提示 :EAS_D_HJ_STANDARD 表空间不存在,并且有一堆 create table语句不能执行我很纳闷 这是什么原因呢??
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716