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. Ask Tom version 3.2.0. consider originally initial=10m next=5m minextents=6. The time now is 04:57 PM. http://renderq.net/unable-to/imp-00003-oracle-error-1658-encountered-ora-01658.php
Multiple extents are not bad!! Senior MemberAccount Moderator I also wanted the output of: select FILE_NAME,TABLESPACE_NAME,BYTES,MAXBYTES from dba_data_files where TABLESPACE_NAME='USERS'; Regards Michel [Updated on: Sat, 06 April 2013 01:26]Report message to a moderator So if your tablespaces are big the workaround is to split the tablespace into several files. Are you aComputer / IT professional?Join Tek-Tips Forums!
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. Senior MemberAccount Moderator Anyway, your file reached 32G which is the maximum size for a (small) file with 8KB block. Get 1:1 Help Now Advertise Here Enjoyed your answer? 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
Checkdba_free_space - you may not have a 426M contiguous extent available. Ora-01659 Make sure you have 'AUTOEXTEND ON' option while creating tablespace. Raf Reply With Quote 07-01-2003,10:34 AM #5 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 Do you have a importing OMS's objects into OMS IMP-00017: following statement failed with ORACLE error 1658: "CREATE TABLE "OMS_BILL_BACK" ("CNSG_NO" VARCHAR2(12), "BILL_REF#" VARCHAR2(" "10), "BKG_DAT" DATE, "CUS_NO" VARCHAR2(10), "SHP_TYP_NO" VARCHAR2(3), "PROD" "_NO" VARCHAR2(2), "SERVICE_NO"
Hemant Patel Sep 20, 2005, 15:33 export with compress=n... https://www.experts-exchange.com/questions/27670073/IMP-00003-ORACLE-error-1658-encountered.html 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 The import utility needs the same tablespaces that existed in the source database to import the tables. Ora-01658 Unable To Create Initial Extent For Segment In Tablespace During Import I suspect if that is the case then in 7/8 you had a login.sql that does the set trimspool and you forgot to move that to 8i.
I know it is related to storage, therefore, have tried below options. 1. Till that it was fine. 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 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 Alter Tablespace Add Datafile Oracle
Close Box Join Tek-Tips Today! PRTG is easy to set up & use. While creating the object oracle was allocating the space (physical) to object.
We imported the same in 11.2 database with just 200M tablespaces size (2 tablespace) and it went fine.
have a peek at these guys The time now is 16:57.
Built with love using Oracle Application Express 5. Ora-31633 Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more. Check the maximum file size that your OS can support.
Close this window and log in. Mahesh Rajendran Sep 20, 2005, 15:11 Hi Mohammad, See if this can help you. 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 Alter Tablespace Autoextend On You mayalso send the HELP command for other information (like subscribing).
Not the answer you're looking for? and import. 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 You can extract the bits you need and edit them as required for the new database.
Now I am trying to export with parameter COMPRESS=N Raf Reply With Quote 07-01-2003,10:58 AM #8 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location all the extents are consolidated into one. 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 dmp log=E:\DUMP\ts.log fromuser=tiger121 touser=tiger statistics=none this my user tiger default tablespace its uses and its a auto extend on and localy managed tablespace,and i have enough space on my drive also..can
importing table "LXRO_DF20A77E" 2339 rows imported . . Your options are: o create the table before you import -- use a smaller INITIAL extent. thanks........ ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.
importing table "TXCLOSEDPERIODS" 1 rows imported . . siddharth kumar Sep 26, 2005, 08:50 sorry did not see the earlier reply abt tablespace...... 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 Does anyone know this encoding?
Asked: September 29, 2000 - 3:55 am UTC Answered by: Tom Kyte � Last updated: September 08, 2003 - 12:43 pm UTC Category: Database � Version: oracle 7.3 Latest Followup You Simply remove MAX's quota on the TOM tablespace in the new instance or take the tablespace offline in the new instance. Execute imp again with ignore=y option Metanil 0 LVL 3 Overall: Level 3 Oracle Database 3 Message Author Comment by:sathya_s2006-04-24 I will check it and let you know. and we said...
Your help is greatly appreciated. RE: ORACLE error 1658 when importing schema dbalearner (TechnicalUser) (OP) 30 Sep 05 16:08 I think I have missed a message Santa. We are trying to import data into an empty table. Thanks Raf Reply With Quote 07-01-03,06:51 #2 AlanP View Profile View Forum Posts Registered User Join Date Mar 2002 Location Reading, UK Posts 1,137 Could be cos its trying to create
You mayalso send the HELP command for other information (like subscribing).------_=_NextPart_001_01C042A9.71B03FFAContent-Type: text/html;charset="iso-8859-1"Content-Transfer-Encoding: quoted-printableRE: IMPORT ERRORSLarry, change your initial/next extent to 100M or =something. Check dba_free_space - more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. High School Trigonometric Integration What is the exchange interaction?