Re: Strange ORA-01653 error

From: Garsen Subramoney <Garsen_at_netactive.co.za>
Date: Fri, 22 Oct 1999 08:20:14 +0200
Message-ID: <7uovsg$s2h$1@nnrp01.ops.uunet.co.za>

Hi Kenneth

Thanks for the reply.

SPS3 is not the temp tablespace for the account i'm using to do the imports.

Curiouser and Curiouser

Thanks

Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message news:380F36B7.2ED1DD0B_at_Unforgettable.com...
> 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.
Received on Fri Oct 22 1999 - 01:20:14 CDT