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: ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

Re: ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

From: Richard Foote <Richard.Foote_at_oracle.com>
Date: Thu, 08 Aug 2002 17:57:36 +1000
Message-ID: <3D522470.4FFD9758@oracle.com>


Hi There,

A quick look at the Error messages manual (hint hint) reveals "An attempt was made to create a temporary segment for a SORT/HASH/LOBS in a locally managed *permanent* tablespace.

Action: Alter temporary tablespace of user to a temporary tablespace or a dictionary-managed permanent tablespace.

It took me approximately 27.29 seconds to look up :)

Regards

Richard

Epicentre team A wrote:
>
> Hi
>
> I've this error when connect. why ?
> Platform SCO UnixWare
> Oracle Server 817
>
> Thanks
> Epicentre Team A


Received on Thu Aug 08 2002 - 02:57:36 CDT

Original text of this message

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