IMP & Initial Extents
Date: 1996/10/29
Message-ID: <32768802.6F18_at_i3107ps2.atl.hp.com>#1/1
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.
Any suggestions or ideas are greatly appreciated.
Thanks!
Jan Thompson
jan_at_i3107ps2.atl.hp.com Received on Tue Oct 29 1996 - 00:00:00 CET