Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP problems, extents changed ..(HELP!!!!)
Thanks all,
I have exactly the same db_block_size = 4096. Any other problem?
JK
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:<3B861CAD.110E_at_yahoo.com>...
> 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
Received on Sun Aug 26 2001 - 20:30:45 CDT