ORA-12901: default temporary tablespace must be of TEMPORARY type

Cause : ina lcoalyl mnaagde dtaabsae,d efualtt emoprayr tbalepsac emuts b eTEPMORRAY ytpe

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


update : 19-08-2017

ORA-12901 - default temporary tablespace must be of TEMPORARY type
ORA-12901 - default temporary tablespace must be of TEMPORARY type

  • ora-25255 : incorrect subscription string string
  • ora-26738 : %s 'string' is not empty
  • ora-01036 : illegal variable name/number
  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • ora-02081 : database link is not open
  • ora-15020 : discovered duplicate ASM disk "string"
  • ora-02243 : invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
  • ora-16245 : paging in transaction string, string, string
  • ora-26765 : invalid parameter "string" for downstream capture "string"
  • ora-36810 : (XSTBLFUNC05) Analytic workspace object number does not exist.
  • ora-12448 : policy string not applied to schema string
  • ora-01512 : error renaming log file string - new file string not found
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-09274 : szrfc: insufficient role name buffer space
  • ora-31423 : change table string does not contain column string
  • ora-22054 : underflow error
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-13626 : The specified object string is not valid for task string.
  • ora-23384 : replication parallel push string argument out of range
  • ora-16807 : unable to change database protection mode
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-07672 : $PARSE_CLASS failed translating the string into a binary label
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-02338 : missing or invalid column constraint specification
  • ora-24280 : invalid input value for parameter string
  • ora-29821 : specified primary operator does not exist
  • ora-27021 : sequential file handle must be specified
  • ora-16577 : corruption detected in Data Guard configuration file
  • 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.