following statement failed with oracle error 1658 Peacham Vermont

Address 101 Depot St, Lyndonville, VT 05851
Phone (802) 626-4144
Website Link

following statement failed with oracle error 1658 Peacham, Vermont

you therefore don't have a 74mb free chunk, hence the allocation will fail) a script (link to a script) is provided here. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... I'm getting either in itial extent or minextent or temp segment error. Hemant Patel Sep 20, 2005, 18:01 Mohammad, My apologies.

I have imported it thrice. Execute the script file(foo.sql) in the user u want to have data. 3. Hemant. In most of the situation the above error occurs when oracle can't allocate space, which means try check your tablespace size(data file will be more specific).

The table doesn't have any indexes on it. How can I solve it and why it happened? 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 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

Covered by US Patent. All rights reserved. If the target does not have this large extent, you will get the error. 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

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. That was a typo. Tried creating bigfile tablespace(with 50g) 3. 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

Click Here to join Tek-Tips and talk with other members! To start viewing messages, select the forum that you want to visit from the selection below. check for the tablespace and the free space available , it could be you are simply that you dont havesufficient space in the tablespace -- so you could autoextend / resize You do not have that.

Close Box Join Tek-Tips Today! 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 I advice you to read: Database Concepts Database 2 Day DBA Administrator's Guide Regards Michel Report message to a moderator Previous Topic: Total estimation using BLOCKS Wisse 14150 7 T.

Join UsClose MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Ask a Hmmm. With the distributed option PL/SQL Release - Production Export file created by EXPORT:V07.01.04 . The time now is 05:48 PM.

Join & Ask a Question Need Help in Real-Time? You mayalso send the HELP command for other information (like subscribing). Register Help Remember Me? Best to do this for this particular table only...

There is no more room in the tablespace, you have to enlarge it. Hemant.... C:\sis): ' accept v_ac_yr_mth prompt 'Please input the extract A/C Year Month (YYYYMM): ' define p_str_dt = '01' set head off select 'Please refer to &&v_outdir\Motor_Claims_Enquiry'||'.txt for the output file' from 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

Hemant Patel Sep 20, 2005, 15:33 export with compress=n... perhaps you are seeing the primary key/unique constraint indexes? Hemant. Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows

Till that it was fine. I tried coalescing BONDDATA tablesapce but could not free up the necessary contigiuous space. do these steps alter tablespace coalesce; also add a data file with minimum extents ie. 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

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 Database Advertise Here 769 members asked questions and received personalized solutions in the past 7 days. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud and I don't want this.

importing table "LXRO_DF20A77E" 2339 rows imported . . Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website! Your help is greatly appreciated. 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

Mufasa(aka Dave of Sandy, Utah, USA)[ 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. Copyright © 2015 Oracle and/or its affiliates. CONTINUE READING Suggested Solutions Title # Comments Views Activity Clearing Non-printing Characters from SQL Server Data from Large File for Import 11 51 107d Oracle SQL Nested Select 3 48 99d Despite what your freespace query may be telling you, those 709MB for the initial extend must be contiguous bytes.