Oracle Error 1659 Encountered
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. imp-00017: following statement failed with oracle error 1659: Please enter a title. You can not post a blank message. Please ora-01659: unable to allocate minextents beyond 2 in tablespace type your message and try again. More discussions in Oracle Database 11g Express Edition Beta All PlacesOracle CommunityArchived alter tablespace add datafile ForumsOracle Database 11g Express Edition Beta This discussion is archived 1 Reply Latest reply on May 28, 2011 9:36 PM by Udo IMP-00003: ORACLE error 1659 encountered 865167 May 28, 2011 8:29 PM Hi, I have created three data files and each is having size 25 GB and it is autoextended to 1 GB. During dump (size 30 GB) import in oracle database i am geeting following error message. IMP-00017: following statement failed with ORACLE error 1659: "CREATE INDEX "IDX$$_055E0001" ON "LXHIST_DFDAEE54" ("LXOID" , "LXKIND" ) P" "CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4294967294 NEXT 1048576 F" "REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) L" "OGGING" IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 14 in tablespace CARRARO IMP-00017: following statement failed with ORACLE error 3113: "BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;" IMP-00003: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel IMP-00000: Import terminated unsuccessfully My Dump file size is 30 GB Total size of disk is 195 GB and free space size is 98.9 GB Could you please provide a solution for this issue. -Arun Edited by: 862164 on May 28, 2011 1:28 PM I have the same question Show 0 Likes(0) 4238Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: IMP-00003: ORACLE error 1659 encountered Udo May 28, 2011 9:36 PM (in response to 865167) Hi Arun, first: Are you sure you are in the right forum? If so, you need to now that Oracle XE comes along with some limitations. One of them is the amount of user data that can be
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 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 > IMP-00003: ORACLE error 1658 encountered Want to Advertise Here? Solved IMP-00003: ORACLE error 1658 encountered Posted on 2012-04-10 Oracle Database https://community.oracle.com/thread/2231930 1 Verified Solution 8 Comments 2,573 Views Last Modified: 2012-04-11 I am getting below error, while trying to import ======= Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export file created by EXPORT:V11.01.00 via conventional path Warning: the objects were exported by SYS, not https://www.experts-exchange.com/questions/27670073/IMP-00003-ORACLE-error-1658-encountered.html by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses AL32UTF8 character set (possible charset conversion) export server uses UTF8 NCHAR character set (possible ncharset conversion) . importing USER's objects into USER IMP-00017: following statement failed with ORACLE error 1659: "CREATE INDEX "CUST_BIRTHDATE_AK1" ON "CUST" ("BIRTHDATE" , "CUST_ID" ," " "HISTORY_VERSION_NUMBER" ) PCTFREE 10 INITRANS 17 MAXTRANS 255 STORAGE(IN" "ITIAL 4294967294 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BU" "FFER_POOL DEFAULT) TABLESPACE "TABLESPACE" LOGGING" IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 28 in tablespace TABLESPACE IMP-00017: following statement failed with ORACLE error 1659: "CREATE INDEX "CUST_ACCT_DOC_ACCT_DOC_FK" ON "CUST_ACCT_DOC" ("ACCT_DOC_ID" " ") PCTFREE 10 INITRANS 17 MAXTRANS 255 STORAGE(INITIAL 982515712 NEXT 10485" "76 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPA" "CE "TABLESPACE" LOGGING" IMP-00003: ORACLE error 1659 encountered 0 Question by:YBSolutions Facebook Twitter LinkedIn Google LVL 12 Best Solution bypraveencpk >>Warning: the objects were exported by SYS, not by you<< it states that the export was taken by sys us
and minextent If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.dbasupport.com/forums/showthread.php?54027-initial-extent-and-minextent 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 4 of 4 Thread: initial http://www.sqlservercentral.com/Forums/Topic1153418-1044-1.aspx extent and minextent Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-01-2007,01:52 AM #1 remya_pn View oracle error Profile View Forum Posts Junior Member Join Date Feb 2007 Posts 1 initial extent and minextent Hi, I have created a new database and I want to import one schema to my new database. While importing I am getting the following errors. If anybody knows what the exact problem is, please help me soon.. Error regarding INITIAL EXTENT IMP-00003: ORACLE error 1658 encountered ORA-01658: oracle error 1659 unable to create INITIAL extent for segment in tablespace TS_ERIC IMP-00017: following statement failed with ORACLE error 1659: "CREATE TABLE "CON_KEY_TRANS" ("AGREEMENT_ID" VARCHAR2(15), "VERSION" NUMBER" "(4, 0), "PRODUCT_NO" VARCHAR2(24), "REVISION_STATE" VARCHAR2(7), "VIA_ID" N" "UMBER(10, 0), "TYPE_ID" NUMBER(38, 0), "PART_DATE_FROM" DATE, "CON_KEY" NUM" "BER(10, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(" "INITIAL 19398656 NEXT 8962048 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50 F" "REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) Error regarding MINEXTENT IMP-00003: ORACLE error 1659 encountered ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace TS_ERIC IMP-00017: following statement failed with ORACLE error 1659: "CREATE TABLE "CON_SUB_OPTION_VALID_VALUES" ("OPTION_ID" NUMBER(10, 0), "VALID_VALUE" VARCHAR2(250)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 19398656 NEXT 8962048 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) " This is the command I have given to create tablespace. CREATE TABLESPACE TS_ERIC DATAFILE 'ERIC01.DMP' SIZE 3072M AUTOEXTEND ON MAXSIZE UNLIMITED MINIMUM EXTENT 1K DEFAULT STORAGE (INITIAL 1K NEXT 60K) LOGGING; I have read that this error can happen because of two reasons ie either tablespace size is small or extent size is too large. Her
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » Working with Oracle » IMP-00058: ORACLE error 1658 encountered on... IMP-00058: ORACLE error 1658 encountered on tablespace users -some pointers/advice needed Rate Topic Display Mode Topic Options Author Message ResenderResender Posted Wednesday, August 3, 2011 5:46 AM SSC-Addicted Group: General Forum Members Last Login: Thursday, December 3, 2015 8:16 AM Points: 465, Visits: 1,558 I'm posting this here cause on the OTN-forum I'm getting nothing but grief and no real help.I'm doing an import of quite a large database via a dmp file, one of the most frequent error is:IMP-00058: ORACLE error 1658 encounteredORA-01658:ORA-01658: unable to create INITIAL extent for segment in tablespace USERS.I've looked up this error and increased the size of my users datafile (up to maxiumum blocksize possible),still I'm getting this error.Anyone can give me a tip on what to do. Post #1153418 PaulB-TheOneAndOnlyPaulB-TheOneAndOnly Posted Saturday, August 6, 2011 12:21 PM Hall of Fame Group: General Forum Members Last Login: Tuesday, January 28, 2014 8:15 AM Points: 3,065, Visits: 4,639 Resender (8/3/2011)I'm posting this here cause on the OTN-forum I'm getting nothing but grief and no real help.I'm doing an import of quite a large database via a dmp file, one of the most frequent error is:IMP-00058: ORACLE error 1658 encounteredORA-01658:ORA-01658: unable to create INITIAL extent for segment in tablespace USERS.I've looked up this error and increased the size of my users datafile (up to maxiumum blocksize possible),still I'm getting this error.Anyone can give me a tip on what to do.Problem is lack of space on USERS tablespace.Not sure what you mean with "maximum blocksize", blocksize h