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
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
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
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
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!
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.