Re: IMP problems, extents changed ..(HELP!!!!)

Sounds like you have a maximum of 121 extents set on either the table or the index. One thing to do is to just alter all the tables and indexes to set there 'maxextents' to be unlimited before the import.

HTH,
Pete's

jkyf0131_at_hotmail.com (JK Yao) wrote in message news:<93f65984.0108231858.4048bc52_at_posting.google.com>...
> dear all,
>
> I export my Oracle7.3.4 database use compress=n. ]
> Then import to Oracle8.1.6. There are some import error for tables
> showing below:
>
> IMP-00058: ORACLE error 1631 encountered
> ORA-01631: max # extents (121) reached in table
> IFSAPP.MANUF_STRUCTURE_TAB
> IMP-00028: partial import of previous table rolled back: 261286 rows
> rolled back
>
> 1. I know the problem is extents too canont be extended. However, in
> the original database those extent is good enough for my data, but why
> cannot fit for Oracle8.1.6? Is that normal?
> Please clarify. How can I solve it?
>
> 2. If this is normal, so should I just import anyway and then alter
> table setting and then import those tables? Or there is better way to
> prevent this kind of import error before I impot it?
>
> thanks in advance for any help.
>
> regards,
> JK
Received on Fri Aug 24 2001 - 08:03:10 CDT