Re: IMP & Initial Extents

Jan Thompson wrote:
> 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

By default IMP will try to put all of the table data in one initial extent. You can't use a dump containing only that table as an estimate, since depending on PCTFREE storage parameter Oracle will reserve "empty" space in each database block.

Use IMP indexfile=info.sql show=y

then you can read the actual table creation parameters from *.sql file, and even edit them and precreate the table before import.

(if you feel brave, read the dump file directly...)

-- 
----------------------------------------------------------------------
Lassi Salo, System Specialist, NTC International Logistics  
Nokia Telecommunications, P.O.Box 33, FIN-02601 Espoo, FINLAND  
Mail: lassi.salo_at_ntc.nokia.com  Phone: +358-0-5112 2725  
Fax: +358-0-5112 2227  Nokia's Home: http://www.nokia.com/  
----------------------------------------------------------------------