Subject: Re: Import/Export facility
References: <>

Paul Taylor  writes:

>Hi there

>I can successfully export and import any size of table, but can only
>import a very small table.  I have tried increasing the 'pctincrease'
>from 0 to 50, which the manual recommends, but I realise it is not a
>good idea to do this anyway. Currently the max extents is set to 99.

>The error messages I receive are as shown below.

>IMP-00003: ORACLE error 1556 encountered
>ORA-01556: maximum number of 99 extents exceeded
>IMP-00021: operating system error - error code (dec 2, hex 0x2)
>IMP-00028: partial import of previous table rollbacked: 1834 rows
>Import terminated successfully with warnings.
>This is all run under Oracle 6.
>Any ideas?
>Thanks in advance for any help.


It is not sufficient in your case to increase the PCT_INCREASE parameter. 
Since you have exceeded the 99 extents, it is clear that your extent sizes
are not large enough.

Set the INITIAL and/or NEXT extent to a larger value (at least 99 times
what they are now to even have a chance of fitting in only one extent).

The default value is 5 data blocks (not much at all - around 20k 
depending on your db_block_size) if not manually defined otherwise. So, if
you took the default value, you may have made your extents too small.

You may have also specified K when you intended to specify M
(kilobytes/megabytes) - so check your storage definitions.

Good luck!

-Ari Kaplan
Independent Oracle DBA Consultant

<-> Visit my Web Page:                          <->
<->             email:                    <->

Back to Ari Kaplan's Home Page ../index.htm">Back to Ari Kaplan's Home Page