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
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.
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
The time now is 17:02. do these steps alter tablespace
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
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