Re: IMPORT error: ORA-1630

Hi

[Quoted] The best thing to do will be to create a temporary TEMP tablespace and set that tablespace as the TEMP tablespace of the user doing the Import. Iam assuming that the user is system. It will go like this:

Create tablespace Temp2
datafile 'filename' size 1500M
default storage
(
initial 500M
next 100M
minextents 1
pctincrease 0
);

alter user system
temporary tablespace Temp2;

You can now do the import. Once completed set the Temporary tablespace of user system back to what it was and drop the Temp2 tablespace.

Let me know what happens

AKader_at_mweb.com

Cheers
Adiel Kader
[Quoted] Brian Yan wrote in message <36229B85.5D36_at_gpu.srv.ualberta.ca>...
>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
Received on Wed Oct 14 1998 - 00:00:00 CEST