Imp-00017 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 facing following error while import. please solve,. With the distributed option PL/SQL Release ora-01658 unable to create initial extent 2.3.4.0.0 - Production Export file created by EXPORT:V07.01.04 . importing OMS's objects ora-01658 solution 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, ora-01658 unable to create initial extent for segment in tablespace during import "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), alter tablespace add datafile oracle "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),
Ora-01658: Unable To Create Initial Extent For Segment In Tablespace Apps_ts_tx_data
"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 is initial 14m next 1m -- it needs 14m of contigous space to create. You do not have that. See http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:112012348062 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 jus
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With
Ora-01659
Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click ora-31633 Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's alter tablespace autoextend on functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132 Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Oracle: Oracle release - 9i and earlier Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesOracle: Oracle release http://www.tek-tips.com/viewthread.cfm?qid=1129932 - 9i and earlier Forum ORACLE error 1658 when importing schema thread759-1129932 Forum Search FAQs Links MVPs ORACLE error 1658 when importing schema ORACLE error 1658 when importing schema dbalearner (TechnicalUser) (OP) 29 Sep 05 13:04 I am getting the following error when I am importing the schema called BONDSIMP-00017: following statement failed with ORACLE error 1658:"CREATE TABLE "ISIN_PRICE" ("CODE_ISIN" VARCHAR2(12) NOT NULL, "PRICE_DATE" ""DATE NOT NULL, "BID_PRICE" NUMBER(12, 7), "BID_YIELD" NUMBER(12, 7), "OFFER""_PRICE" NUMBER(12, 7), "OFFER_YIELD" NUMBER(12, 7), "GOVT_MARGIN" NUMBER(12"", 7), "SWAP_MARGIN" NUMBER(12, 7), "FUTURE_MARGIN" NUMBER(12, 7), "MARGIN_S""IDE" VARCHAR2(1), "MARGIN_FREQ" NUMBER(2, 0))PCTFREE 10 PCTUSED 40 INITRA""NS 1 MAXTRANS 255 STORAGE(INITIAL 709355520 NEXT 26214400 MINEXTENTS 1 MAXE""XTENTS 115 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "BONDDAT""A""IMP-00003: ORACLE error 1658 encounteredORA-01658: unable to create INITIAL extent for segment in tablespace BONDDATAI have enough space in the relevant tablesapceTABLESPACE_NAMEFree/MB------------------------------ ----------BONDDATA6557The Oracle version is 7.3.4Thanks,Learner RE: ORACLE error 1658 when importing schema SantaMufasa (TechnicalUser) 29 Sep 05 13:21 Learner,The import is asking for your i
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 Full Time https://www.experts-exchange.com/questions/21824429/Problem-while-importing.html 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 while importing http://grokbase.com/t/freelists.org/oracle-l/00ayme42cz/import-errors Want to Advertise Here? Solved Problem while importing Posted on 2006-04-23 Oracle Database 1 Verified Solution 7 Comments 17,088 Views Last Modified: 2012-06-27 Hi, When I import a dump, which is of size unable to 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 PCTUSED 40 INITRANS 1 unable to create 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 "LXRO_DF3C99AE" ("LXTOLAT" , " ""LXTOID" ) PCTFREE 10 IN
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.com4