Re: IMP & Initial Extents

Jan Thompson <jant_at_i3107ps2.atl.hp.com> wrote:

>Hello world:
 

>I have a question about EXP/IMP, particularly IMP.
 

>My IMP version is 7.2.2.4.0 running on HP 9000.
 

>When I ran IMP on various sized files from 4 rows to 15,000 rows,
>it ran fine without any warnings or errors.
 

>But when I ran it on a data file that is 26MB (I had used EXP to
>produce the data file) I got this error:
 

> IMP-00003: Oracle error 1658 encountered
> ORA-01658: Unable to create Initial extent for segment
> in tablespace SPC3.
 

>The initial extent was originally 10K. But even when I increased
>it to 2048K I still got the above error.
 

>Well, 61,440KB. Surely there's room for the 26MB file to fit into
>61.5MB.
 

>Anyway, there are the other parameters for this tablespace:
 

> Next Extent : 10K
> Minimum Extents : 1
> Maximum Extents : 121
> Percentage Increase : 50
 

>Can you tell by the above limited information as to what is wrong?
>I'm sure that some of you have encountered the same problems before
>in some previous iterations of the newsgroup.

Jan,

I'm not sure (from the information given) if this is relevant, but is the tablespace clean (ie just created), or has it been used for other stuff (such as the smaller imports you mentioned before). This leads to the question: Is the 60+ Mb you mentioned the total free space for the tablespace, or the largest free "chunk". It may be that you don't have enough contiguous space to lay down the first extent (especially if the data was exported with the COMPRESS=Y option).

If you have the export on disk, run it through more or pg, and check the initial extent size of the first object it is trying to import. Then check the largest chunk of space available by connecting as SYSTEM (or other DBA-priv user), and running:

        SELECT MAX(bytes) FROM DBA_FREE_SPACE

This will tell you if you have enough space to load the object.

Hope this helps.

Steve McDougall Received on Wed Oct 30 1996 - 00:00:00 CET