Following Statement Failed With Oracle Error 1658
Contents |
2003 - 12:43 pm UTC Category: Database – Version: oracle 7.3 Latest Followup You Asked hi, I am
Ora-01658 Unable To Create Initial Extent
facing following error while import. please solve,. With the distributed ora-01658 solution option PL/SQL Release 2.3.4.0.0 - Production Export file created by EXPORT:V07.01.04 . importing OMS's objects into
Ora-01658 During Import
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" alter tablespace add datafile oracle 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" ora-01658: unable to create initial extent for segment in tablespace apps_ts_tx_data 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 we 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
unable to create INITIAL extent If this is your first visit, be sure to check out the FAQ by clicking
Ora-01659
the link above. You may have to register before you can ora-31633 post: click the register link above to proceed. To start viewing messages, select the forum that you
Alter Tablespace Autoextend On
want to visit from the selection below. Results 1 to 9 of 9 Thread: ORA-01658: unable to create INITIAL extent Tweet Thread Tools Show Printable Version Email this https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132 Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-01-2003,05:14 AM #1 raf View Profile View Forum Posts Member Join Date Jul 2002 Posts 228 ORA-01658: unable to create INITIAL extent hi, I've exported my instance: EXP SYSTEM/MANAGER@INSTANCE FULL=Y FILE=C:\EXP_FILE.DMP LOG=C:\ERROR_EXP.LOG after I've created new tablespace and new http://www.dbasupport.com/forums/showthread.php?37250-ORA-01658-unable-to-create-INITIAL-extent user: CREATE TABLESPACE MAX DATAFILE 'c:\MAX01.dbf' SIZE 3800M REUSE DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 256 PCTINCREASE 0) ONLINE; CREATE USER MAX IDENTIFIED BY MAX DEFAULT TABLESPACE MAX TEMPORARY TABLESPACE TEMP; finally I've imported tom's objects in MAX: IMP SYSTEM/MANAGER@INSTANCE FROMUSER=TOM TOUSER=MAX FILE=C:\EXP_FILE.DMP LOG=C:\ERROR_IMP.log but in some tables I get these errors: IMP-00017: following statement failed with ORACLE error 1658: "CREATE TABLE "AREA" ("OFL" VARCHAR2(4), "OBL" VARCHAR2(32), "OSITE" V" "ARCHAR2(32), "OLS" VARCHAR2(32), "OAREA" NUMBER, "DV_ID" VARCHAR2(32), "DP_" "ID" VARCHAR2(32), "ODISMESSO" VARCHAR2(2), "OTYPE" VARCHAR2(64), "OCAT" VAR" "CHAR2(64), "OOCCUP" NUMBER, "SFL" VARCHAR2(32), "SBL" VARCHAR2(32), "SSITE"" " VARCHAR2(32), "PRORATE" VARCHAR2(8), "STYPE" VARCHAR2(64), "SCAT" VARCHAR2" "(64), "SAREA" NUMBER, "SOCCUP" NUMBER, "AREA_SERV" NUMBER) PCTFREE 10 PCTU" "SED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 314572800 NEXT 52428" "800 MINEXTENTS 1 MAXEXTENTS 1000 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS " "1 BUFFER_POOL DEFAULT) TABLESPACE "TOM"" IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace TOM I tried to increase tablespace MAX
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a https://www.experts-exchange.com/questions/21824429/Problem-while-importing.html Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Problem http://grokbase.com/t/freelists.org/oracle-l/00ayme42cz/import-errors while importing Want to Advertise Here? Solved Problem while importing Posted on 2006-04-23 Oracle Database 1 Verified Solution 7 Comments 17,085 Views Last Modified: 2012-06-27 Hi, When I import a dump, which is unable to of size 28 GB I get the following error. I have imported it thrice. I'm getting either in itial extent or minextent or temp segment error. This is really urgent. (1) IMP-00017: following statement failed with ORACLE error 1659: "CREATE TABLE "LXRO_DC96E183" ("LXOID" NUMBER(*,0), "LXFLAGS" NUMBER(*,0), "" "LXTYPE" NUMBER(*,0), "LXFROMLAT" NUMBER(*,0), "LXFROMID" NUMBER(*,0), "LXTO" "LAT" NUMBER(*,0), "LXTOID" NUMBER(*,0), "LXCRDATE" DATE, "LXRELRUL" NUMBER(" "*,0)) PCTFREE 10 unable to create PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIA" "L 21012480 FREELISTS 1 FREELIST GROUPS 1) " IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace METSO_TBS . . importing table "LXRO_DD0E3175" 1 rows imported . . importing table "LXRO_DE93EC06" IMP-00058: ORACLE error 1653 encountered ORA-01653: unable to extend table METSO.LXRO_DE93EC06 by 128 in tablespace METSO_TBS IMP-00028: partial import of previous table rolled back: 80063 rows rolled back . . importing table "LXRO_DF038E1C" 0 rows imported . . importing table "LXRO_DF20A77E" 2339 rows imported . . importing table "LXRO_DF3C99AE" IMP-00058: ORACLE error 1653 encountered ORA-01653: unable to extend table METSO.LXRO_DF3C99AE by 8 in tablespace METSO_TBS IMP-00028: partial import of previous table rolled back: 6239 rows rolled back IMP-00017: following statement failed with ORACLE error 1658: "CREATE INDEX "LXRO_DF3C99AE_LXTOLAT_INDEX" ON "L
errors.I added a 1 gig datafile to TABLESPACE IQ01IDX01, but still got the sameerrors.Does anyone have a suggestion?IMP-00003: ORACLE error 1658 encounteredORA-01658: unable to create INITIAL extent for segment in tablespaceIQ01IDX01IMP-00017: following statement failed with ORACLE error 1658:"CREATE UNIQUE INDEX "PK_FDFAF_C_ID" ON "DW_FLOW_ACTION_FACT" ("C_ID" )PCT""FREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 447651840 NEXT 223715328MI""NEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1BUFF""ER_POOL DEFAULT) TABLESPACE "IQ01IDX01" LOGGING"IMP-00003: ORACLE error 1658 encounteredORA-01658: unable to create INITIAL extent for segment in tablespaceIQ01IDX01IMP-00017: following statement failed with ORACLE error 1658:"ALTER TABLE "DW_FLOW_ACTION_FACT" ADD CONSTRAINT "PK_FDFAF_C_ID" PRIMARYK""EY ("C_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL""447651840 NEXT 223715328 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50FREELIS""TS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "IQ01IDX01" ENABLE"IMP-00003: ORACLE error 1658 encounteredORA-01658: unable to create INITIAL extent for segment in tablespaceIQ01IDX01 reply Tweet Search Discussions Search All Groups oracle-l 4 responses Oldest Nested Koivu, Lisa This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C042A9.71B03FFA Content-Type: text/plain; charset="iso-8859-1" Larry, change your initial/next extent to 100M or something. Check dba_free_space - you may not have a 426M contiguous extent available. Also, you can try coalescing your tablespace - you will see the results immediately in dba_Free_space. Multiple extents are not bad!! HTH Koivu, Lisa at Oct 30, 2000 at 7:41 pm ⇧ This message is in MIME format. Since your mail reader does not understandthis format, some or all of this message may not be legible.------_=_NextPart_001_01C042A9.71B03FFAContent-Type: text/plain;charset="iso-8859-1"Larry, change your initial/next extent to 100M or something. Checkdba_free_space - you may not have a 426M contiguous extent available. Also,you can try coalescing your tablespace - you will see the resultsimmediately in dba_Free_space.Multiple extents are not bad!!HTHLisa Rutland KoivuOracle Database AdministratorQode.com4850 North State Road 7Suite G104Fort Lauderdale, FL 33319V: 954.484.3191, x174F: 954.484.2933C: 954.658.5849http://www.qode.com"The info