Oracle Error 1658
Contents |
2003 - 12:43 pm UTC Category: Database � Version: oracle 7.3 Whilst you are here, check out some content from the AskTom team: The Joy ora-01658 unable to create initial extent of Low Hanging Fruit, Part 1 Latest Followup You Asked hi, I
Ora-01658 Solution
am facing following error while import. please solve,. With the distributed option PL/SQL Release 2.3.4.0.0 - Production
Alter Tablespace Add Datafile Oracle
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,
Ora-01658 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), "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 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_QUEST
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 ora-01659 Messages: 380Registered: April 2011 Location: gujarat Senior Member hello while importing data ora-31633 i got this error in my log file.and i cannot import my data successfuly in my log file error alter tablespace autoextend on 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: IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132 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 managed tablespace,and i have enough space on my drive also..can you hint me what http://www.orafaq.com/forum/t/187005/ 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: 20850Registered: 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 management auto so its not allocate spaces automatic little foot my tablespaces details are under SQL> select TABLESPACE_NAME,EXTENT_MANAGEMENT,SEGMENT_SPACE_MANAGEMENT from dba_ tablespaces; TABLESPACE_NAME EXTENT_MAN SEGMEN ------------------------------ ---------- ------ SYSTEM
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips http://www.tek-tips.com/viewthread.cfm?qid=1129932 Forums! Talk With Other Members Be Notified Of ResponsesTo Your http://www.dbforums.com/showthread.php?833622-ORA-01658-unable-to-create-INITIAL-extent Posts 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 unable to and thesis posting is forbidden.Tek-Tips Posting 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 unable to create - 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 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------------------------------ ----------BONDDATA6557T
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: ORA-01658: unable to create INITIAL extent Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-01-03,05:23 #1 raf View Profile View Forum Posts Registered User Join Date Jul 2002 Posts 227 Unanswered: 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 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 c