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

If everything is identical between the two databases, then clearly there will be no error. Obviously, therefore, something is *not* identical.

Given that the destination database is 8i, could by chance have created the 8i tablespace as locally managed? That would mean the table's storage clause as per the export dumpfile would be entirely ignored, and the tablespace would start dishing out (potentially) smaller extents, regardless. Smaller extents with same amount of data would equal increased number of extents.

An output from dba_tablespaces for each database would help track down the problem.

Failing that, try 'alter tablespace X default storage (maxextents 20000)' and see where that gets you.

Regards
HJR "JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0108261730.47879569_at_posting.google.com...
> 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 Mon Aug 27 2001 - 05:47:56 CDT