ORA-12918: Invalid tablespace type for default permanent tablespace

Cause : hT eatlbseapeci siehtred orppde ,etpmrora yrou dno

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

hCce kht eatlbseapect py ena dersius eht etstamenet

update : 25-04-2017
ORA-12918

ORA-12918 - Invalid tablespace type for default permanent tablespace
ORA-12918 - Invalid tablespace type for default permanent tablespace

  • ora-31618 : dump file size too small
  • ora-38434 : could not evaluate expression "string"
  • ora-13335 : LRS measure information not defined
  • ora-27419 : unable to determine valid execution date from repeat interval
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-01309 : invalid session
  • ora-30071 : conversion between datetime/interval and string fail
  • ora-02372 : data for row: string
  • ora-24079 : invalid name string, names with AQ$_ prefix are not valid for string
  • ora-30931 : Element 'string' cannot contain mixed text
  • ora-13801 : invalid value for SQLTUNE_CATEGORY parameter
  • ora-16702 : generic resource guard warning
  • ora-01763 : update or delete involves outer joined table
  • ora-19035 : Invalid select item of the query in newContextFromHierarchy()
  • ora-36165 : (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
  • ora-31425 : subscription does not exist
  • ora-13209 : internal error while reading SDO_INDEX_METADATA table
  • ora-01254 : cannot end online backup - file string in recovery manager backup
  • ora-19767 : missing TRACKING keyword
  • ora-33332 : (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
  • ora-15191 : Internal ASM testing event number 15191
  • ora-26566 : Couldn't open connect to string
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-28356 : invalid open wallet syntax
  • ora-32844 : exceeded maximum number of string values
  • ora-00223 : convert file is invalid or incorrect version
  • ora-28603 : statement not permitted on empty tables
  • ora-29273 : HTTP request failed
  • ora-31154 : invalid XML document
  • 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.