Imp-00003 Oracle Error 1658 Encountered
Contents |
2003 - 12:43 pm UTC Category: Database � Version: oracle 7.3
Imp-00003 Oracle Error 959 Encountered
Latest Followup You Asked hi, I am facing following imp 00003 oracle error 1435 encountered error while import. please solve,. With the distributed option PL/SQL Release 2.3.4.0.0 - ora-01658 unable to create initial extent 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
Ora-01658 Unable To Create Initial Extent For Segment In Tablespace During Import
"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,
Alter Tablespace Add Datafile
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.
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 Member hello while importing data i got this error in my log file.and i cannot import my data successfuly in my log file error i found like this ORA-01658: unable to create INITIAL extent for segment in tablespace https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132 USERS IMP-00017: following statement failed with ORACLE error 1658: 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 http://www.orafaq.com/forum/t/187005/ 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 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 #5
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are http://www.tek-tips.com/viewthread.cfm?qid=1129932 you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your 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 oracle error 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 Your Site By Linking To This Professionally Managed Technical Forum.Just copy and 00003 oracle error 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 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