Home > Unable To > Imp-00003 Oracle Error 1658 Encountered Ora-01658

Imp-00003 Oracle Error 1658 Encountered Ora-01658

Contents

I exported the dmp from instance 'FIRE' and imported to instance 'LUKE' touser=MAX Raf Reply With Quote 07-01-2003,10:28 AM #4 raf View Profile View Forum Posts Member Join Date Jul 2002 Kavsek 15350 6 P. Your table is initial 14m next 1m -- it needs 14m of contigous space to create. That was a typo. this contact form

Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more. Therefore to see if you have that much contiguous freespace available in BONDDAT, please run this query and post the results:CODE*****************************************************************************col bytes format 999,999,999,999select max(bytes) bytes from dba_free_space where tablespace_name = But I find that the output of the file have space between the records. RE: ORACLE error 1658 when importing schema dbalearner (TechnicalUser) (OP) 30 Sep 05 16:08 I think I have missed a message Santa. https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132

Ora-01658 Unable To Create Initial Extent

You cannot delete your own events. how can I import schema to a different tablespace? The table doesn't have any indexes on it. Privacy Policy Site Map Support Terms of Use Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books

Terms of Use. 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 http...... Alter Tablespace Add Datafile Oracle Join & Ask a Question Need Help in Real-Time?

Followup September 08, 2003 - 12:43 pm UTC constraints=no as well ? Ora-01658 Solution 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. 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 navigate to this website Click Here to join Tek-Tips and talk with other members!

You cannot post events. Ora-01659 If you have a decent text editor if shouldn't be that bad to search for STORAGE and delete to the end of the statement. You cannot post new polls. Cadot 37400 2 F.

Ora-01658 Solution

You cannot edit other posts. We have in the import clause indexes=n. Ora-01658 Unable To Create Initial Extent And add the result of: select block_size from dba_tablespaces where TABLESPACE_NAME='USERS'; Also, FORMAT your output with code tags. Ora-01658 Unable To Create Initial Extent For Segment In Tablespace During Import 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

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. You are getting ORA-1658: unable to create INITIAL extent for segment in tablespace OMS. 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 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: Mahesh Ora-01658: Unable To Create Initial Extent For Segment In Tablespace Apps_ts_tx_data

Wisse 14150 7 T. 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: Hemant Senior MemberAccount Moderator Execute "set numwidth 20" and post the result of your command. navigate here Tried creating bigfile tablespace(with 50g) 3.

You cannot post topic replies. Ora-31633 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 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

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:

The time now is 17:02. do these steps alter tablespace coalesce; also add a data file with minimum extents ie. Best to do this for this particular table only... Alter Tablespace Autoextend On You cannot post replies to polls.

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 Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Oracle ORA-01658: unable to create INITIAL extent If this is Simply remove MAX's quota on the TOM tablespace in the new instance or take the tablespace offline in the new instance. perhaps you are seeing the primary key/unique constraint indexes?

Privacy Policy. 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 Copyright © 2002-2016 Simple Talk Publishing. 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

Do you know if there is any solution for it? 0 Message Author Comment by:YBSolutions2012-04-10 Just FYI, I have changed table name and tablespace name. 0 LVL 12 Overall: please solve,. Into a small file with 8K block size, yes. 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 About Feedback Search Pirats Poll questions Change log

You cannot post JavaScript. 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 Tried to create sqlfile from dump and run it (by changing some storage values) not all. Diaz 33800 3 J.

Copyright © 2015 Oracle and/or its affiliates. SELECT TABLESPACE_NAME TBSP_NAME , USED_SPACE, TABLESPACE_SIZE TBSP_SIZE, USED_PERCENT FROM SYS.DBA_TABLESPACE_USAGE_METRICS; 0 LVL 16 Overall: Level 16 Oracle Database 15 Message Expert Comment by:Wasim Akram Shaik2012-04-11 The cause of the error