Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> IMP problems, extents changed ..(HELP!!!!)

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

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 23 Aug 2001 19:58:50 -0700
Message-ID: <93f65984.0108231858.4048bc52@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 Thu Aug 23 2001 - 21:58:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US