Have you ascertained that you don't actually have those initial extent sizes
for your tables on the source DB? And how about precreating the tables as
well?

Regards,
George

-----Original Message-----
From: Raja Ravipati [mailto:[Email Address Removed] Tuesday, October 30, 2001 12:23 PM
To: LazyDBA.com Discussion
Subject: RE: Import failure - Urgent!!!!!!!!!!!!!!!!!!!!!!!!


I feel, it is trying to place whole table into one extent. Do you have
autoextend on?. I got into same problem with autoextend on.

Raja

> -----Original Message-----
> From: session session [SMTP:[Email Address Removed] Sent: Tuesday, October 30, 2001 2:17 PM
> To: LazyDBA.com Discussion
> Subject: Import failure - Urgent!!!!!!!!!!!!!!!!!!!!!!!!
>
> Hi Gurus,
>
> I am trying to create a new instance of our production database on a new
> machine.
>
> I precreated all the tablespaces and the application user on the target
> database.
>
> On the source database, I did a ful database export with the following
> parameters through a pipe:
>
> exp userid=system/psswd file=fullexportcompress_pipe rows=Y indexes=Y
> compress=N grants=Y constraints=Y full=Y log=fullimpeexp.log
>
> On the target database I am using the following import parameters:
>
> imp userid=system/psswd file=import_pipe full=Y buffer=10000000 ignore=Y
> commit=Y log=fullimp.log
>
> However, I am getting the following errors:
>
> IMP-00003: ORACLE error 1658 encountered
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> ADVANCE_DATA
> IMP-00017: following statement failed with ORACLE error 1658:
> "CREATE TABLE "TEMP_XXX" ("I_SESSION_ID" VARCHAR2(10), "TEMP_DONOR_ID""
> " VARCHAR2(10), "TEMP_RECEIPT_NUMBER" VARCHAR2(10), "TEMP_DATE_OF_RECORD"
> DA"
> "TE, "TEMP_ASSOCIATED_AMOUNT" NUMBER(14, 2), "TEMP_ASSOCIATED_CREDIT_AMT"
> NU"
> "MBER(14, 2), "TEMP_CREDIT2_AMT" NUMBER(14, 2), "TEMP_ANNUAL_SW"
> VARCHAR2(1)"
> ", "TEMP_TYPE" VARCHAR2(1)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
>
> L"
> "OGGING STORAGE(INITIAL 2097152 NEXT 2099200 MINEXTENTS 1 MAXEXTENTS 4096
> PC"
> "TINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
>
> ""
> "DATA""
> IMP-00003: ORACLE error 1658 encountered
> ORA-01658: unable to create INITIAL extent for segment in tablespace DATA
>
> When I look at the tablespace in OEM, it is maxed out. Even though the
> source tablespace is 5GB and the target tablespace is 9GB.
>
> I can see through TOAD that the initial extents for some of the tables are
>
> '2097152', how can this be if I used compress=N during the export?
>
> Please help.
> -- Session.
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page