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 : 20-09-2017

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

  • ora-06730 : TLI Driver: unable to open clone device
  • ora-13061 : topology with the name string does not exist
  • ora-19207 : scalar parameter string of XMLELEMENT cannot have an alias.
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-29661 : Unable to find the superclass of the defined in the EXTERNAL NAME
  • ora-12321 : database (link name string) is not open and AUTO_MOUNTING=FALSE
  • ora-29311 : export dump file was not generated by this database, string does not match
  • ora-01567 : dropping log string would leave less than 2 log files for instance string (thread string)
  • ora-23291 : Only base table columns may be renamed
  • ora-21610 : size [string] is invalid
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-31667 : parameter name can not be defaulted
  • ora-02452 : invalid HASHKEYS option value
  • ora-38859 : instance string (thread string) is not ready to be disabled
  • ora-35282 : (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
  • ora-29555 : Java source, class or resource is not allowed here
  • ora-14400 : inserted partition key does not map to any partition
  • ora-28650 : Primary index on an IOT cannot be rebuilt
  • ora-06005 : NETASY: dialogue file read failure
  • ora-24399 : invalid number of connections specified
  • ora-01097 : cannot shutdown while in a transaction - commit or rollback first
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-02820 : Unable to write the requested number of blocks
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-15156 : cluster in rolling upgrade from version [string] to [string]
  • ora-02256 : number of referencing columns must match referenced columns
  • ora-39161 : Full database jobs require privileges
  • ora-39140 : dump file "string" belongs to job string
  • ora-12094 : error during online redefinition
  • ora-13783 : invalid tuning scope
  • 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.