Imp-00003 Oracle Error 1658 Encountered Ora-01658
Contents |
2003 - 12:43 pm UTC Category: Database � Version: oracle 7.3 Latest Followup You Asked hi, I am facing following error while ora-01658 unable to create initial extent import. please solve,. With the distributed option PL/SQL Release 2.3.4.0.0 - ora-01658 solution Production Export file created by EXPORT:V07.01.04 . importing OMS's objects into OMS IMP-00017: following statement failed ora-01658 unable to create initial extent for segment in tablespace during import 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), ora-01658: unable to create initial extent for segment in tablespace apps_ts_tx_data "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"
Alter Tablespace Add Datafile Oracle
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 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 Messages :: Show Polls :: Message Navigator E-mail to friend ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581303] Thu, 04 April 2013 05:49 x-oracle Messages: 380Registered: April 2011 Location: gujarat Senior ora-31633 Member hello while importing data i got this error in my log file.and i cannot import my alter tablespace autoextend on data successfuly in my log file error i found like this ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following statement failed with ORACLE error 1658: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132 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 1658: i can import my data using imp utility using this syntax C:\Users\Administrator>imp tiger/****@tcs file=E:\DUMP\ts. dmp log=E:\DUMP\ts.log fromuser=tiger121 touser=tiger statistics=none this my user tiger default tablespace its uses and its a auto extend on and localy http://www.orafaq.com/forum/t/187005/ managed tablespace,and i have enough space on my drive also..can you hint me what can i do to resolve this error [Updated on: Thu, 04 April 2013 05:52]Report message to a moderator Re: ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581304 is a reply to message #581303] Thu, 04 April 2013 05:59 Littlefoot Messages: 20843Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator Oracle says Quote: ORA-01658: unable to create INITIAL extent for segment in tablespace string Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created. Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL Report message to a moderator Re: ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581305 is a reply to message #581304] Thu, 04 April 2013 06:14 x-oracle Messages: 380Registered: April 2011 Location: gujarat Senior Member but my tablespaces segment space Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts http://www.tek-tips.com/viewthread.cfm?qid=1129932 Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's 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 Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To unable 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 - 9i and earlier Forum ORACLE error 1658 when importing schema thread759-1129932 Forum Search FAQs Links MVPs ORACLE error 1658 when importing schema ORACLE unable to create 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 initial extent to be 709MB in the BONDDAT tablespace. Despite what your freespace query may be telling you, those 709MB for the initial extend must be contiguous bytes. Therefore to see if you have that much contiguous freespace available in BONDDAT, please run this query and post the resulOra-01659