Home > Unable To > Ora-01658 Unable To Create Initial Extent

Ora-01658 Unable To Create Initial Extent

Contents

importing table "LXRO_DF9B7015" 621 rows imported . . Senior MemberAccount Moderator Add a new file as Littlefoot told you in the very first answer. Solved IMP-00003: ORACLE error 1658 encountered Posted on 2012-04-10 Oracle Database 1 Verified Solution 8 Comments 2,552 Views Last Modified: 2012-04-11 I am getting below error, while trying to import ======= However, the import is still trying to create indexes and the import is failing because there is not enough space for the index. his comment is here

Quote:tablespace its uses and its a auto extend Show us. But it is around 15K lines code. Regards Michel Report message to a moderator Re: ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581377 is a reply to Sathya 0 LVL 3 Overall: Level 3 Oracle Database 3 Message Author Comment by:sathya_s2006-06-06 Hi Metanil, Creating multiple datafiles worked...Maxsize for a single datafile is 32GB.

Ora-01658 Unable To Create Initial Extent

Check dba_free_space - you may not have a 426M contiguous extent available. Thanks Raf Reply With Quote 07-01-2003,05:24 AM #2 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 Even though you Thanks, Sathya 0 LVL 47 Overall: Level 47 Oracle Database 47 Message Expert Comment by:schwertner2006-04-24 Linux/Unix in their 32 bit versions do not support filis greater then 2 GB.

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 Hemant.... IMP-00017: following statement failed with ORACLE error 1658: "CREATE INDEX "HISTFILEIX" ON "HISTFILE" ("DAT" , "TRA" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 74618880 NEXT 37285888 MINEXTENTS 1 MAXE Ora-01658: Unable To Create Initial Extent For Segment In Tablespace Apps_ts_tx_data Multiple extents are not bad!!

REM (1) Control the output format set serveroutput on size 50000 set lin 500 set echo off set feedback off set pagesize 50000 set arraysize 100 set verify off set underline Ora-01658 Solution but have specified the storage clauses to the data file when you had added.. Connect with top rated Experts 8 Experts available now in Live! Get 1:1 Help Now Advertise Here Enjoyed your answer?

To start viewing messages, select the forum that you want to visit from the selection below. Ora-01659 importing table "LXRO_DFC688A9" 0 rows imported IMP-00017: following statement failed with ORACLE error 1658: "CREATE INDEX "LXRO_DFC688A9_LXOID_INDEX" ON "LXRO_DFC688A9" ("LXOID" 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" I'm getting these errors after 18 hours of import.

Ora-01658 Solution

Try this: alter TABLESPACE IQ01IDX01 coalesce; select bytes from dba_free_space where tablespace_name='IQ01IDX01' order by bytes desc; Check to see if Hamid Alavi at Oct 30, 2000 at 8:45 pm ⇧ Tom,This importing table "LXRO_DD0E3175" 1 rows imported . . Ora-01658 Unable To Create Initial Extent Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Ora-01658 During Import and import.

You may have to register before you can post: click the register link above to proceed. this content Show us current size and max size. Report message to a moderator Re: ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581382 is a reply to message #581381] The only way I know of is what you have already mentioned: Create a script form the export and edit it to remove the large storage values. Alter Tablespace Add Datafile Oracle

Close Box Join Tek-Tips Today! table AREA import correctly but I get same error on others tables: IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace TOM IMP-00017: following statement importing table "LXRO_DF20A77E" 2339 rows imported . . weblink 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.

Reply With Quote 07-01-2003,10:39 AM #6 anandkl View Profile View Forum Posts Senior Advisor Join Date Aug 2001 Location chennai,bangalore Posts 840 You can do an alternate do an import where Ora-31633 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 You do not have that. ......

Asked: September 29, 2000 - 3:55 am UTC Answered by: Tom Kyte – Last updated: September 08, 2003 - 12:43 pm UTC Category: Database – Version: oracle 7.3 Latest Followup You

Thanks... Now I am trying to export with parameter COMPRESS=N Raf Reply With Quote 07-01-2003,10:58 AM #8 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Thanks Mohammad Goto: Reply-Top of page If you think this item violates copyrights, please click here Subject: Re: IMP-00017: failed with ORACLE error 1658: Author: Mahesh Rajendran, Other Date: Sep 20, Alter Tablespace Autoextend On 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

Senior MemberAccount Moderator So your tablespace reached is max size and so the error. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. 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 check over here That's what we are doing, since we have a handful of really big tables, and the important remainder is about 10% of DB size only. 0 Message Author Closing Comment

Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third Register Help Remember Me? and what can i do in rac database if my this tablespace size are full. 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!

If I can suggest an alternative: DBMS_METADATA. Hmmm. That means the tablespace OMS you have setup does not 14m of contigous free space in it. Not importing table's indexes September 08, 2003 - 12:27 pm UTC Reviewer: Ishaque Hussain from Fords, NJ USA We are using Oracle version 8.1.7.4.5.

and i...... Regards Michel Report message to a moderator Re: ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581415 is a reply to As it happens in prod these tablespaces were quite full up. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use.

all the extents are consolidated into one. http...... Reviews Write a Review Import table's Indexes July 02, 2002 - 6:15 am UTC Reviewer: Irfan from Kuwait Hi Tom, I have got enough space in tablespace and when trying to