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

IMPORT error: ORA-1630

From: Brian Yan <by2_at_gpu.srv.ualberta.ca>
Date: 1998/10/12
Message-ID: <36229B85.5D36@gpu.srv.ualberta.ca>#1/1 






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 Mon Oct 12 1998 - 00:00:00 CDT












Original text of this message













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