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 : 23-06-2017

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

  • ora-30131 : number of keys being set exceeds allocation
  • ora-21707 : pin duration is longer than allocation duration
  • ora-29928 : duplicate default selectivity specified
  • ora-01298 : conflicting dictionary option
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-01412 : zero length not allowed for this datatype
  • ora-02229 : invalid SIZE option value
  • ora-07240 : slemrd: seek error.
  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-02739 : osncon: host alias is too long
  • ora-23374 : object group "string"."string" already exists
  • ora-19581 : no files have been named
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-31017 : Error generating unique OID for XML document
  • ora-26006 : Incorrect bind variable in column string's sql expression - string
  • ora-19931 : file string has invalid creation SCN string
  • ora-13779 : invalid load option
  • ora-13386 : commit/rollback operation error: [string]
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-22970 : name does not correspond to an object view
  • ora-02213 : duplicate PCTUSED option specification
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-12851 : PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
  • ora-01524 : cannot create data file as 'string' - file already part of database
  • ora-13260 : layer table string does not exist
  • ora-09955 : scgcan: unexpected return status when canceling a lock
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • ora-00712 : cannot rename system tablespace
  • ora-16504 : the Data Guard configuration already exists
  • ora-03203 : concurrent update activity makes space analysis impossible
  • 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.