ORA-12951: Attempt to change default permanent tablespace to temporary

Cause : It is icnorrect ot alter hte defautl permannet tablepsace of adatabas eto temproary type

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


update : 23-08-2017

ORA-12951 - Attempt to change default permanent tablespace to temporary
ORA-12951 - Attempt to change default permanent tablespace to temporary

  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-16059 : Log file is empty or invalid next available block
  • ora-19953 : database should not be open
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-01202 : wrong incarnation of this file - wrong creation time
  • ora-29393 : user string does not exist or is not logged on
  • ora-02097 : parameter cannot be modified because specified value is invalid
  • ora-22604 : TDS handle already generated
  • ora-12098 : cannot comment on the materialized view
  • ora-02092 : out of transaction table slots for distributed transaction
  • ora-39088 : file name cannot contain a path specification
  • ora-01037 : maximum cursor memory exceeded
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-27040 : file create error, unable to create file
  • ora-29871 : invalid alter option for a domain index
  • ora-29377 : consumer group string is not part of top-plan string
  • ora-06926 : CMX: T_ERROR during read data
  • ora-06709 : TLI Driver: message send failure
  • ora-25206 : enqueue failed, enqueue to exception queue string.string not permitted
  • ora-12354 : secondary object being dropped
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-31488 : cannot support change set string in this configuration
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-16005 : database requires recovery
  • ora-33070 : (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
  • ora-00100 : no data found
  • ora-37005 : (AWLISTALL03) number readers
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-13841 : SQL profile named string already exists for a different signature/category pair
  • 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.