当前位置: 代码迷 >> Oracle管理 >> ORACLE error 1658,该如何解决
  详细解决方案

ORACLE error 1658,该如何解决

热度:111   发布时间:2016-04-24 05:57:06.0
ORACLE error 1658
. . importing table "TRNGRPIAINVQTY" 0 rows imported
. . importing table "TRNHSTF" 0 rows imported
. . importing table "TRNPRCTYP" 200 rows imported
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE TABLE "TRNSCTF" ("FTRN1" CHAR(3) NOT NULL ENABLE, "FTRN2" CHAR(3) NO"
 "T NULL ENABLE, "FTRNNO" NUMBER NOT NULL ENABLE, "FSLIPNO" CHAR(15), "FLOTNO"
 "" CHAR(10), "FLOTNO2" NUMBER, "FODRNO" CHAR(10), "FPURODRNO2" NUMBER, "FPRJ"
 "NO" CHAR(10), "FITEMNO" CHAR(15), "FFROMWHCD" CHAR(6), "FFROMLCTCD" CHAR(6)"
 ", "FTOWHCD" CHAR(6), "FTOLCTCD" CHAR(6), "FTRNQTY" NUMBER(18, 6), "FUNIT" C"
 "HAR(2), "FACTTRNQTY" NUMBER(18, 6), "FTRNUNIT" CHAR(2), "FTRNPRC" NUMBER(18"
 ", 6), "FACTPRC" NUMBER(18, 6), "FCURR" CHAR(3), "FTRNRATE" NUMBER(12, 6), ""
 "FRSNCD" CHAR(3), "FTRNDTE" DATE, "FINVUPDFLG" CHAR(1), "FMTUSUPFLG" CHAR(1)"
 ", "FDONEQTY" NUMBER(18, 6), "FENTDT" VARCHAR2(19), "FENTUSR" VARCHAR2(8), ""
 "FUPDTEDT" VARCHAR2(19), "FUPDTEUSR" VARCHAR2(8), "FUPDTEPRG" VARCHAR2(110),"
 " "FRATEDATE" CHAR(8), "FNOTE" CHAR(60), "FOLEPATH" VARCHAR2(254), "FWARECD""
 " CHAR(6), "FCSTFLG" CHAR(1), "FCHARGETYP" CHAR(6), "FFSBATCHNO" CHAR(10), ""
 "FPLNSALESDTE" DATE, "FINVAMT" NUMBER(18, 6), "FINVOICEFLG" CHAR(1), "FCOINV"
 "FLG" CHAR(1), "FCOTYPE" CHAR(2), "FPOTYPE" CHAR(2), "FCHARGESECT" CHAR(6), "
 ""FINVCNO" CHAR(23), "FLINE" FLOAT(126), "CACHE1" CHAR(100), "CACHE2" CHAR(1"
 "00), "CACHE3" CHAR(100)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOG"
 "GING STORAGE(INITIAL 456523776 NEXT 5472256 MINEXTENTS 1 MAXEXTENTS 2147483"
 "645 PCTINCREASE 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
 "PACE "USERS""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
IMP-00017: following statement failed with ORACLE error 942:
 "AUDIT DELETE,INSERT,UPDATE ON "TRNSCTF" BY ACCESS WHENEVER SUCCESSFUL"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
. . importing table "TRNTYPGRPT" 0 rows imported
. . importing table "TTLCAEXPENSE" 0 rows imported
. . importing table "TTLCGCOSTDRVM" 0 rows imported

------解决方案--------------------
原因是表空间容量不够了,扩展表空间后,再试。
  相关解决方案