Re: IMP & Initial Extents

From: Chakravarthy Nalamotu <kittu_at_gis.eng.hawaii.edu>
Date: 1996/10/30
Message-ID: <55831b$hhc_at_news.Hawaii.Edu>#1/1


You have a Percentage Increase: 50.
Which increases the extent size by 50% everytime a new segment is aquired, and it has a compound effect. Usually Percentage Increase is 0 (zero), unless you wanted the segment size to increase.   Kittu.

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.
 

: Any suggestions or ideas are greatly appreciated.
 

: Thanks!
 

: Jan Thompson
 

: jan_at_i3107ps2.atl.hp.com
Received on Wed Oct 30 1996 - 00:00:00 CET

Original text of this message