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 -> Re: Strange ORA-01653 error

Re: Strange ORA-01653 error

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Thu, 21 Oct 1999 11:52:23 -0400
Message-ID: <380F36B7.2ED1DD0B@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 Thu Oct 21 1999 - 10:52:23 CDT

Original text of this message

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