Home » RDBMS Server » Server Administration » ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace [message #53243] Fri, 06 September 2002 06:22 Go to next message
Helena
Messages: 42
Registered: February 2002
Member
Hi there
I'm having the following problems with oracle, I can't find any solutions
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 declare days_to_delay integer:=0;
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P020
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-06512: at line 17
Can someone please help me with this one

Thanks
Helena
Re: ORA-03212: Temporary Segment cannot be created in locally-managed tablespace [message #53245 is a reply to message #53243] Fri, 06 September 2002 07:26 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
change the tablespace to dictionary managed.
Previous Topic: pfile and spfile
Next Topic: Update primary key value
Goto Forum:
  


Current Time: Thu Sep 19 12:12:11 CDT 2024