ORA-10919: Default temporary tablespace group must have at least one tablespace

Cause : Ana ttmeptw asm ad etom ov eth eonyl tbalepsac eint hed efualtd atbaas etepmorray atblsepaec gorupt o naotehr atblsepaec gorup.

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

Eihterc hagne hte adtaabsed efualtt emoprayr tbalepsac eora dda nohtert abelspcae ot teh gorupt ha tthsi tbalepsac ebeolng sto.

update : 25-06-2017
ORA-10919

ORA-10919 - Default temporary tablespace group must have at least one tablespace
ORA-10919 - Default temporary tablespace group must have at least one tablespace

  • ora-23403 : refresh group "string"."string" already exists
  • ora-06134 : NETTCP: file access privilege violation
  • ora-10639 : Dump library cache during kksfbc-reparse-infinite-loop error
  • ora-38435 : missing elementary attribute value or invalid name-value pairs
  • ora-01329 : unable to truncate required build table
  • ora-24319 : unable to allocate memory
  • ora-23433 : executing against wrong master site string
  • ora-04060 : insufficient privileges to execute string
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-12808 : cannot set string_INSTANCES greater than number of instances string
  • ora-30556 : functional index is defined on the column to be modified
  • ora-00399 : corrupt change description in redo log
  • ora-29305 : cannot point-in-time recover tablespace 'string'
  • ora-00229 : operation disallowed: already hold snapshot control file enqueue
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-21501 : program could not allocate memory
  • ora-36964 : (XSRELTBL09) workspace object is not a valid level relation.
  • ora-38505 : invalid default value for the attribute
  • ora-26663 : error queue for apply process string must be empty
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-24033 : no recipients for message
  • ora-16409 : Archive log switchover reference number mismatch
  • ora-16119 : building transaction at SCN string
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-10575 : Give up restoring recovered datafiles to consistent state: out of memory
  • ora-28140 : Invalid column specified
  • ora-39119 : worker process interrupt for delete worker processes call by master process
  • 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.