ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

Cause : An tatemtp wa smad eto foflien a atblepsacei n teh deafultd ataabse etmpoarry atblepsaceg rou.p

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

Eitehr cahnget he adtabsae dfeaul ttemoprar ytabelspaec orc haneg th etabelspaec gruop o fthi stabelspaec.

update : 22-09-2017
ORA-10920

ORA-10920 - Cannot offline tablespace belonging to default temporary tablespace group
ORA-10920 - Cannot offline tablespace belonging to default temporary tablespace group

  • ora-27481 : "string.string" has an invalid schedule
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-27068 : I/O buffer is not aligned properly
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-31658 : specifying a schema name requires a table name
  • ora-02818 : Less than the number of blocks requested was read in
  • ora-00267 : name of archived log file not needed
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-33462 : (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-30964 : The XML Index was not usable.
  • ora-02842 : Client unable to fork a server
  • ora-02830 : Segment could not be split - no free segments available
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-29525 : referenced name is too long: 'string'
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-38955 : Source platform string not cross platform compliant
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-07594 : spiip: $GETJPIW failure
  • ora-02723 : osnpui: cannot send break signal
  • ora-16075 : standby database destination mismatch
  • ora-00321 : log string of thread string, cannot update log file header
  • ora-13832 : category name specified is invalid
  • ora-24167 : incompatible rule engine objects, cannot downgrade
  • ora-19103 : VALUE keyword keyword
  • ora-30103 : 'string' contains an illegal integer radix for 'string'
  • ora-40106 : positive target value not specified for computing Lift
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-07685 : sou2os: supervisor stack set error
  • ora-19930 : file string has invalid checkpoint SCN string
  • 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.