Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange ORA-01653 error
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 Thu Oct 21 1999 - 10:52:23 CDT