Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange ORA-01653 error
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