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 : 24-05-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-14056 : partition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-32052 : failed to start mapping service
  • ora-07253 : spdes: semctl error, unable to destroy semaphore set.
  • ora-01225 : thread number string is greater than MAXINSTANCES string
  • ora-13630 : The task string contains execution results and cannot be executed.
  • ora-19235 : XQ0015 - unsupported must-understand extension
  • ora-12661 : Protocol authentication to be used
  • ora-25117 : MIN/MAX/Block Number expected
  • ora-13441 : GeoRaster metadata SRS error
  • ora-30351 : query rewrite does not currently support this expression
  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-02760 : Client close of file failed.
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-15066 : offlining disk "string" may result in a data loss
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-02285 : duplicate START WITH specifications
  • ora-30657 : operation not supported on external organized table
  • ora-00334 : archived log: 'string'
  • ora-06109 : NETTCP: message receive failure
  • ora-00569 : Failed to acquire global enqueue.
  • ora-16002 : database already open for read-write access by another instance
  • ora-38411 : invalid datatype for the column storing expressions
  • ora-17624 : Failed to delete directory string
  • ora-03007 : obsolete feature
  • ora-07744 : slemcl: invalid error message file handle
  • ora-02398 : exceeded procedure space usage
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-32025 : %s.string is not a table or view object.
  • ora-24439 : success with PLSQL compilation warning
  • 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.