You Asked
hi,
I am facing following error while import.
please solve,.
With the distributed option
PL/SQL Release 2.3.4.0.0 - Production
Export file created by EXPORT:V07.01.04
. importing OMS's objects into OMS
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "OMS_BILL_BACK" ("CNSG_NO" VARCHAR2(12), "BILL_REF#" VARCHAR2("
"10), "BKG_DAT" DATE, "CUS_NO" VARCHAR2(10), "SHP_TYP_NO" VARCHAR2(3), "PROD"
"_NO" VARCHAR2(2), "SERVICE_NO" VARCHAR2(3), "SEC_NO" VARCHAR2(3), "ORGN" VA"
"RCHAR2(3), "DSTN" VARCHAR2(3), "WTT_BKG" NUMBER(9, 2), "WTT_ACT" NUMBER(9, "
"2), "PAY_MODE_NO" VARCHAR2(3), "BKG_STAF_NO" VARCHAR2(5), "OT_SRVS_AMT" NUM"
"BER(12, 2), "HNDLG_CHRG" NUMBER(12, 2), "OTHER_CHRG" NUMBER(12, 2), "AMOUNT"
"" NUMBER(12, 2), "PARTNER_AMT" NUMBER(12, 2), "PART_COMM" NUMBER(12, 2), "A"
"MT_CAL" NUMBER(12, 2), "HNDLG_INST" VARCHAR2(3), "EXCISE" NUMBER(11, 2), "C"
"NSG_VAL" NUMBER(12, 2), "INSUR_AMT" NUMBER(10, 2), "ROUTE_NO" VARCHAR2(5), "
""USERID" VARCHAR2(20), "SYSID" VARCHAR2(10), "DISCOUNT_SHIP" NUMBER(12, 2),"
" "DISCOUNT_BOTT" NUMBER(12, 2), "DISCOUNT_FREQ" NUMBER(12, 2), "INCEN_AMT" "
"NUMBER(12, 2), "CREATE_DATIME" DATE, "SCAN_STAT2" VARCHAR2(1), "SCAN_DATE" "
"DATE, "RPT_DATE" DATE, "EOD_STATUS" VARCHAR2(1), "BILL_STATUS" VARCHAR2(1),"
" "INC_STATUS" VARCHAR2(1), "CUT_OF_DATE" DATE, "PED" NUMBER(11, 2), "OCTROI"
"" NUMBER(11, 2), "CMD_CODE" VARCHAR2(3), "PHASE" VARCHAR2(2), "STAFF_NO" VA"
"RCHAR2(8), "DISCOUNT" VARCHAR2(1)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRA"
"NS 255 STORAGE(INITIAL 14735360 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 121 PC"
"TINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "OMS""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace OMS
Import terminated successfully with warnings.
and Tom said...
That seems to be somewhat self explainatory. You are getting
ORA-1658: unable to create INITIAL extent for segment in
tablespace OMS.
That means the tablespace OMS you have setup does not 14m of contigous free space in it. Your table is initial 14m next 1m -- it needs 14m of contigous space to create. You do not have that.
See
</code>
http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:112012348062 <code>for a script that will show you how much space is in a tablespace as well as the largest contigous free chunk of space.
Your options are:
o create the table before you import -- use a smaller INITIAL extent. when you import, use IGNORE=Y to ignore object creation errors (so import will just load the table, not create it)
o add more space to the tablespace or, if there are lots of free space chunks that are adjacent, try issuing "alter tablespace OMS coalesce" and then running the FREE.SQL script again to see if you have 14m or better as the largest chunk.
Rating
(3 ratings)
Is this answer out of date? If it is, please let us know via a Comment