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

JK Yao wrote:
>
> 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

Are the blocksizes the same ???

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."