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

Imp-00017 Following Statement Failed With Oracle Error 1658

Contents

Your help is greatly appreciated. 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 #581422 is a reply to Connect with top rated Experts 12 Experts available now in Live! and i...... this contact form

Ask Tom Sign In QuestionsArchivesPopularHotResourcesAbout Questionsproblem with import Breadcrumb Question and Answer Thanks for the question, zaibi. Simply remove MAX's quota on the TOM tablespace in the new instance or take the tablespace offline in the new instance. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. RE: ORACLE error 1658 when importing schema dbalearner (TechnicalUser) (OP) 29 Sep 05 13:22 In alert log I found the following message:Thu Sep 29 17:18:47 2005ORA-1652: unable to extend temp segment see this

Ora-01658 Unable To Create Initial Extent

Privacy Policy Site Map Support Terms of Use Welcome to DBA-Village, your primary Oracle DBA information source.Geert De Paep Forum ->Thread 14506 Home Account Register Update account Forgot password This site thanks........ As it happens in prod these tablespaces were quite full up. imp username/password INDEXFILE= where file in indexfile parameter would contain all the DDL's, edit it to include the new tablespace and execute the same in the new schema regards anandkl anandkl

Followup September 08, 2003 - 12:43 pm UTC constraints=no as well ? The above message does it refer to temporary teablespace or bonddata [email protected]> select max(bytes) bytes from dba_free_space where tablespace_name = 'BONDDATA';BYTES----------------605,429,760 RE: ORACLE error 1658 when importing schema SantaMufasa (TechnicalUser) 29 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 Ora-01658: Unable To Create Initial Extent For Segment In Tablespace Apps_ts_tx_data Close Box Join Tek-Tips Today!

Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C042A9.71B03FFA Content-Type: text/plain; charset="iso-8859-1" Larry, change your initial/next extent to 100M or Ora-01658 Solution Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. The time now is 16:57. http://www.dbasupport.com/forums/showthread.php?37250-ORA-01658-unable-to-create-INITIAL-extent Schnackenberg 17800 4 B.

Reply With Quote 07-01-2003,10:25 AM #3 raf View Profile View Forum Posts Member Join Date Jul 2002 Posts 228 I've increase tablespace TOM from 2.7Gb to 3.8Gb and after I've again Ora-01659 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 Reply With Quote 07-04-2003,05:55 AM #9 raf View Profile View Forum Posts Member Join Date Jul 2002 Posts 228 I tried 2 solution: 1) I've taken the tablespace TOM offline in You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Tom PallINET: tom_at_cdproc.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California

Ora-01658 Solution

segmentsize=35+(5*5)=60m So, COMPRESS=N will avoid this. https://www.experts-exchange.com/questions/27670073/IMP-00003-ORACLE-error-1658-encountered.html How to find the maximum file zise my OS supports? Ora-01658 Unable To Create Initial Extent IMP-00017: following statement failed with ORACLE error 1658: ========================== "CREATE TABLE "PKAAT" ("TRANSACTION_ID" CHAR(10) NOT NULL ENABL" "E, "ULTIMESTAMP" DATE NOT NULL ENABLE, "ROW_STATUS" VARCHAR2(10) NOT NULL E" "NABLE, "ERROR_CODE" NUMBER(*,0), Ora-01658 Unable To Create Initial Extent For Segment In Tablespace During Import importing D7IDMP's objects into MIGRATE . .

do these steps alter tablespace coalesce; also add a data file with minimum extents ie. The OERR utility shows this.. Senior MemberAccount Moderator ALTER DATABASE DATAFILE ... Your table is initial 14m next 1m -- it needs 14m of contigous space to create. Alter Tablespace Add Datafile Oracle

Hemant. Show us current size and max size. I have nearyl 143 MB of free space in that tablespace whereas the initial extent requires only 74 MB. navigate here Set Screen Reader Mode On Integrated Cloud Applications and Platform Services About Oracle Contact Us Legal Notices Terms of Use Your Privacy Rights All information and materials provided here are provided

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, Ora-31633 users last 24h20Act. Oracle Database Taking User Managed Backups with Oracle Video by: Steve This video explains what a user managed backup is and shows how to take one, providing a couple of simple

importing table "TXBARESC" 178 rows imported . .

  1. Note: I think if I will remove the storage parameters (for indexes and tables) from sqlfile (created from dump) than it should work.
  2. 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 #581419 is a reply to
  3. 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.
  4. Solved IMP-00003: ORACLE error 1658 encountered Posted on 2012-04-10 Oracle Database 1 Verified Solution 8 Comments 2,553 Views Last Modified: 2012-04-11 I am getting below error, while trying to import =======
  5. That means the tablespace OMS you have setup does not 14m of contigous free space in it.
  6. All rights reserved.
  7. Built with love using Oracle Application Express 5.
  8. 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
  9. RE: ORACLE error 1658 when importing schema dbalearner (TechnicalUser) (OP) 29 Sep 05 15:27 Thanks Santa I added adiitional space to both BONDDATA and BONDTEMP tablespaces.

Thanks... Already a member? That was a typo. Alter Tablespace Autoextend On 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!

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 Get Your Free Trial! try creating the table with a smaller intial extent and let oracle handle the extents if you don't want to alter datafile .. re-read the answer here -- it describes exactly your issue. ....

Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. If the target does not have this large extent, you will get the error. 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. If your OS doesn't support big files, then try creating multiple data files for a tablespace.

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! 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 Tried creating bigfile tablespace(with 50g) 3. Sorry for teh late response.