Re: Strange ORA-01653 error

From: -= <aquabubble_at_my-deja.com>
Date: Fri, 22 Oct 1999 13:01:49 GMT
Message-ID: <7upn7s$qtj$1@nnrp1.deja.com>

In article <380F36B7.2ED1DD0B_at_Unforgettable.com>, BlueSax_at_Unforgettable.com wrote:
> Garsen Subramoney wrote:
> >
> > Hi
> >
> > I've gotten a ORA-01653 error message, however it is a very strange
message.
> >
> > I am doing an import of data into a table SPS_LIVE.SPT_GRN_LOCS in
the
> > SPS_LIVE tablespace. I get the following error:
> >
> > "ORA-01653: unable to extend table SPS_LIVE.SPT_GRN_LOCS by 710 in
> > tablespace SPS3"
> >
> > There are linkages of any kind between tablespace SPS_LIVE &
Tablespace
> > SPS3.
> >
> > Why would i get that kind of a error message.
> >
> > Thanks
>
> SPS3 is probably the temporary tablespace for the account that you are
> using to perform the import. You either need to enlarge that
tablespace or
> else assign a different temporary tablespace.

Or you could possibly use unrecoverable mode to import it.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 08:01:49 CDT