Re: IMPORT error: ORA-1630

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