(no subject)

Paul Taylor wrote:
>
> 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,

        Pre-create the table (with an apporpriate SQL*Plus command) with the INITIAL value determined by the size of the exported table plus whatever I.F.F. (International Fudge Factor) you might want for growth.
jc. Received on Thu Jun 13 1996 - 00:00:00 CEST