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

Cause : Attempt to create a temporary segment for sort/hash/lobs in in permanent tablespace of kind locally-managed

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 21-09-2017
ORA-03212

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

  • ora-14605 : Name missing for subpartition / lob segment in template
  • ora-26048 : Scoped REF column has wrong table name.
  • ora-16569 : Data Guard configuration is not enabled
  • ora-07708 : sksaprs: tape label name buffer too small
  • ora-16751 : resource guard encountered errors in switchover to primary database
  • ora-32144 : Cannot perform operation on a null interval
  • ora-36740 : A CHILDLOCK was detected in your valueset
  • ora-32822 : subscriber string is marked for removal
  • ora-12470 : NULL or invalid user label: string
  • ora-00352 : all logs for thread string need to be archived - cannot enable
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-19590 : conversation already active
  • ora-01625 : rollback segment 'string' does not belong to this instance
  • ora-40106 : positive target value not specified for computing Lift
  • ora-02781 : Invalid value given for the timing wanted flag
  • ora-31515 : CDC change source string already exists
  • ora-02158 : invalid CREATE INDEX option
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-27092 : size of file exceeds file size limit of the process
  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-25234 : NEXT_TRANSACTION navigation option invalid for queue table string.string
  • ora-25137 : Data value out of range
  • ora-23436 : missing template authorization for user
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-12230 : TNS:Severe Network error occurred in making this connection
  • ora-02817 : Read failed
  • ora-37023 : (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
  • ora-12805 : parallel query server died unexpectedly
  • ora-06404 : NETCMN: invalid login (connect) string
  • ora-36694 : (XSRELTBL01) The value cannot be added to dimension workspace object.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.