ORA-12916: Cannot use default permanent tablespace with this release

Cause : T oues edfual tpremnaetn atbelsapc eteh erlaes esohudl eb 01. 0o rhgihre

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

Cehc kteh ocmaptbiiilt ystetniga n driesuset h esattmeetn

update : 25-05-2017
ORA-12916

ORA-12916 - Cannot use default permanent tablespace with this release
ORA-12916 - Cannot use default permanent tablespace with this release

  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-24777 : use of non-migratable database link not allowed
  • ora-23317 : a communication failure has occurred
  • ora-40306 : wide data not supported for decision tree model create
  • ora-39163 : A sample size of string is invalid.
  • ora-23422 : Oracle Server could not generate an unused job number
  • ora-23406 : insufficient privileges on user "string"
  • ora-09813 : Unable to get directory status
  • ora-27071 : unable to seek to desired position in file
  • ora-16586 : could not edit database property through instance
  • ora-24148 : cannot drop rule string.string with dependents
  • ora-08237 : smsget: SGA region not yet created
  • ora-10580 : Can not modify datafile header during test recovery
  • ora-09354 : Windows 32-bit Two-Task driver: ORACLE task unexpectedly died
  • ora-28665 : table and partition must have same compression attribute
  • ora-31071 : Invalid database username or GUID string
  • ora-00308 : cannot open archived log 'string'
  • ora-12996 : cannot drop system-generated virtual column
  • ora-30375 : materialized view cannot be considered fresh
  • ora-19594 : control file already included as string
  • ora-28542 : Error in reading HS init file
  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-00312 : online log string thread string: 'string'
  • ora-32737 : Hang analysis aborted due to failed memory allocation
  • ora-12606 : TNS: Application timeout occurred
  • ora-15204 : database version string is incompatible with diskgroup string
  • ora-00911 : invalid character
  • ora-12163 : TNS:connect descriptor is too long
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-32315 : REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load
  • 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.