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

Imp-00003 Oracle Error 1658 Encountered Ora-01658

Contents

Into a small file with 8K block size, yes. check for the tablespace and the free s...... I get error because not exist tablespace TOM 2)I removed MAX's quota on the TOM tablespace in the new instance. You cannot send emails. navigate here

Report message to a moderator Re: ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat [message #581420 is a reply to message #581419] Followup September 08, 2003 - 12:43 pm UTC constraints=no as well ? but i am have the same problm still same error while importing data IMP-00003: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following 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 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:860427314132

Ora-01658 Unable To Create Initial Extent

Join & Ask a Question Need Help in Real-Time? Join our community for more solutions or to ask questions. marcello.travassos Localização: São Paulo/SP Veja também Respostas ExibiÇões Última mensagem IMP-00017: following statement failed with ORACLE error 6550 por BELLOO 3Respostas 2213Exibies ltima mensagem por diegolenhardt Exibir mensagens anteriores: Todas as Quote:f my data are so much so what can i do..

  1. Crie uma tablespace maior que não seja a SYSTEM e crie seu schema "securitas1".
  2. Set Screen Reader Mode On Integrated Cloud Applications and Platform Services About Oracle Contact Us Legal Notices Terms of Use Your Privacy Rights All information and materials provided here are provided
  3. There is no more room in the tablespace, you have to enlarge it.
  4. Anyway I extended this tablespace and the import went OK.
  5. Subramaniam 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47786Total

If I can suggest an alternative: DBMS_METADATA. 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 Oracle calulates all currently allocated space and uses that as size of the initial extent for the target object. Alter Tablespace Add Datafile Oracle Diaz 33800 3 J.

When I import again fromuser=tom touser=max........... perhaps you are seeing the primary key/unique constraint indexes? ALTER USER MAX QUOTA unlimited ON TOM; but when I import I get alway the same error: ORA-01658: unable to create INITIAL extent for segment in tablespace TOM I know That http://www.orafaq.com/forum/t/187005/ I gather it "used to work" in 7 or 8 and you are saying "it doesn't work" in 8i.

Quote:tablespace its uses and its a auto extend Show us. Ora-01659 With the distributed option PL/SQL Release 2.3.4.0.0 - Production Export file created by EXPORT:V07.01.04 . and I don't want this. all the extents are consolidated into one.

Ora-01658 Solution

Join Us! *Tek-Tips's functionality depends on members receiving e-mail. http://glufke.net/oracle/viewtopic.php?t=4724 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 Ora-01658 Unable To Create Initial Extent Jos Koeken Sep 21, 2005, 14:48 Hi , 1. Ora-01658 Unable To Create Initial Extent For Segment In Tablespace During Import Well this time was the turn of BONINDEX tablespace to throw ORA-1652 error.

Your table is initial 14m next 1m -- it needs 14m of contigous space to create. Any Idea how I can resolved it. Members Search Help Register Login Home Home» RDBMS Server» Server Utilities» ORA-01658: unable to create INITIAL extent for segment in tablespace USERS IMP-00017: following stat (oracle 10g,windows 7 64 bit,) Show: Senior MemberAccount Moderator Quote:so michel only 32 gb data i can insert into one datafile. Ora-01658: Unable To Create Initial Extent For Segment In Tablespace Apps_ts_tx_data

http://asktom.oracle.com/pls/ask/f?p=4950:8:16236319379875866037::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:860427314132 Study it closely, some information is there. Hemant. I have tried to allocate more space under tablespaces (size..autoextend on next ..maxsize...) 2. his comment is here 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

Results 1 to 3 of 3 Thread: ORA-01658: unable to create INITIAL extent Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Ora-31633 You cannot delete other topics. It is easy to write a small PL/SQL script providing you with the list of tables excluding some, which aren't necessary for your tests.

when you import, use IGNORE=Y to ignore object creation errors (so import will just load the table, not create it) o add more space to the tablespace or, if there are

Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me? 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: Jos What i meant is export with compress=N. Alter Tablespace Autoextend On 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

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 By joining you are opting in to receive e-mail. All rights reserved. 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!