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 -> Re: IMPORT error: ORA-1630

Re: IMPORT error: ORA-1630

From: GHouck <hksys_at_teleport.com>
Date: 1998/10/13
Message-ID: <3622B179.25C8@teleport.com>#1/1

Brian Yan wrote:
>
> I am importing a big schema to a new schema. It fails when it is
> importing a big table (contains five millions rows). The error message
> is: ORA-1630: Max # (505) extents reached on TEMP tablespace. I noticed
> that the TEMP tablespace was created without specifying the storage
> parameters. I am wondering what cause the problem and how can I fix it.
> Thank you in advance for your help!
>

Brian,

Did you specify the COMMIT=Y option? It is nearly impossible to import a database of any size without it.

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Tue Oct 13 1998 - 00:00:00 CDT

Original text of this message

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