Newsgroups: comp.databases.oracle
Subject: Re: Import/Export facility
References: <31BEF67F.41C67EA6@pia.bt.co.uk>
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
>rollbacked
>Import terminated successfully with warnings.
>This is all run under Oracle 6.
>Any ideas?
>Thanks in advance for any help.
>Paul
Paul,
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: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page