Home > Unable To > Imp-00017 Following Statement Failed With Oracle Error 1658

Imp-00017 Following Statement Failed With Oracle Error 1658

Contents

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. Register Help Remember Me? Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me? Regards, Your rating?: This reply is Good Excellent 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: http://colvertgroup.com/unable-to/imp-00003-oracle-error-1658-encountered-ora-01658.php

All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Close this window and log in. Are that 3 GB avalilable at the time of its creation? Once again add a file. click to read more

Ora-01658 Unable To Create Initial Extent

ALTER USER MAX QUOTA unlimited ON TOM; but when I import I get alway the same error: ORA-01658: unable to create INITIAL extent for segment in tablespace TOM I know That In this article I'll describe what I did and share my script. users last hour0Registered user hits last week525Registered user hits last month6331 Go up IMP-00017: failed with ORACLE error 1658: Next thread: IFS or BLOB Prev thread: duplicate database using RMAN from Oracle Database Using the Oracle Datapump Export and Import Utilities Video by: Steve This video shows how to Export data from an Oracle database using the Datapump Export Utility.

  1. 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
  2. but i am have the same problm still same error while importing data IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following
  3. We have in the import clause indexes=n.
  4. Registration on or use of this site constitutes acceptance of our Privacy Policy.
  5. Mufasa(aka Dave of Sandy, Utah, USA)[www.dasages.com: Providing low-cost remote Database Admin services]Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.
  6. In this article I'll describe what I did and share my script.
  7. Featured Post Looking for New Ways to Advertise?
  8. share|improve this answer answered Jun 5 '12 at 10:03 Alex Poole 86.6k55893 please see my question with update –Maddy Jun 5 '12 at 10:50 1 I don't think
  9. 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.
  10. 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"

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 But I find that the output of the file have space between the records. This is why increasing the size of the MAX tablespace has no effect. Ora-01658: Unable To Create Initial Extent For Segment In Tablespace Apps_ts_tx_data ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.

you may well have 143mb of free space but the largest contigous chunk of free space may well be something like 1m (you might have 143 - 1mb free chunks. Ora-01658 Solution PRTG is easy to set up & use. I have imported it thrice. http://www.dbasupport.com/forums/showthread.php?37250-ORA-01658-unable-to-create-INITIAL-extent Note: I think if I will remove the storage parameters (for indexes and tables) from sqlfile (created from dump) than it should work.

do these steps alter tablespace coalesce; also add a data file with minimum extents ie. Ora-01659 http...... All rights reserved. importing table "TXCOMPANIES" 1 rows imported . .

Ora-01658 Solution

Join Now For immediate help use Live now! https://www.experts-exchange.com/questions/27670073/IMP-00003-ORACLE-error-1658-encountered.html Vroman 15850 5 A. Ora-01658 Unable To Create Initial Extent That seems to be somewhat self explainatory. Ora-01658 Unable To Create Initial Extent For Segment In Tablespace During Import alter tablespace add datafile min extents <10> max extents unlimited; 0 LVL 76 Overall: Level 76 Oracle Database 74 Message Active today Expert Comment by:slightwv (䄆 Netminder)2012-04-11 Since

Login with LinkedIN Or Log In Locally Email or Username Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert If you haven't already, look at the import parameters in the documentation. The following summarizes the status:SQL*Plus: Release 3.3.4.0.0 - Production on Thu Sep 29 20:24:53 2005Copyright (c) Oracle Corporation 1979, 1996.All rights reserved.Connected to:Oracle7 Server Release 7.3.4.0.0 - ProductionWith the distributed and 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. Alter Tablespace Add Datafile Oracle

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 Multiple extents are not bad!! Thanks & regards, Sathya 0 Question by:sathya_s Facebook Twitter LinkedIn Google LVL 9 Best Solution byMetanil OK here is the clue 1. his comment is here and we said...

I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or… Oracle Database Downloading Oracle Log Files in AWS RDS Article Ora-31633 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! importing table "TXALLTXTS" 245628 rows imported . .

How to find the maximum file zise my OS supports?

Senior MemberAccount Moderator Execute "set numwidth 20" and post the result of your command. Mufasa(aka Dave of Sandy, Utah, USA)[www.dasages.com: Providing low-cost remote Database Admin services]Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA. Complete syntax in Database SQL Reference. Alter Tablespace Autoextend On HTH Koivu, Lisa at Oct 30, 2000 at 7:41 pm ⇧ This message is in MIME format.

importing table "TXCLASSES" 980 rows imported . . Connect with top rated Experts 10 Experts available now in Live! set trimspool on and try again. Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

ORA-39000 / ORA-39143 Errors0Oracle export import issue0Oracle Import Error - Field Length0Oracle Import option1Error while importing an Oracle 9 dump in Oracle 11g Hot Network Questions Sci-Fi movie, about binary code, 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, siddharth kumar Sep 26, 2005, 08:50 sorry did not see the earlier reply abt tablespace...... Your table is initial 14m next 1m -- it needs 14m of contigous space to create.

How to draw a horizontal rule with a colour gradient? 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] Look at the error ORA-01658: unable to create INITIAL extent for segment in tablespace TOM Remove all quotas on TOM tablespace from user MAX or take the tablespace offline Regards Jim I'm getting either in itial extent or minextent or temp segment error.

Also clean alert.log file and the listener.log file that grow very fast and can prevent Oracle to work fine. 0 LVL 3 Overall: Level 3 Oracle Database 3 Message Author Till that it was fine. That means the tablespace OMS you have setup does not 14m of contigous free space in it. Are you aComputer / IT professional?Join Tek-Tips Forums!

When I import again fromuser=tom touser=max........... I made a script to download the Alert Log, look for errors, and email me the trace files. You could also use a tool like TOAD to generate a schema script to create all your tables (but with no data) and then use imp to import the data.