ORA-10644: SYSTEM tablespace cannot be default temporary tablespace

Cause : Whne SSYTE Mtalbesapcei s ebin gmirgatde n ousre sohul dhaev SSYTE Mast hed efualtt emoprayr tbalepsac.e

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

Resisu ethsi cmomadn atfera ltrein gth edeaful ttepmorray atblsepaec stetign fro all uesrs.

update : 19-08-2017
ORA-10644

ORA-10644 - SYSTEM tablespace cannot be default temporary tablespace
ORA-10644 - SYSTEM tablespace cannot be default temporary tablespace

  • ora-06526 : Unable to load PL/SQL library
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-19269 : XQ0049 - variable string defined multiple times
  • ora-32331 : type "string"."string" is incompatible with the master site
  • ora-30334 : illegal dimension level name
  • ora-39168 : Object path string was not found.
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-26526 : materialized view sql ddl parse/expansion failed for string.string
  • ora-12989 : invalid value for checkpoint interval
  • ora-00230 : operation disallowed: snapshot control file enqueue unavailable
  • ora-09744 : smsget: mmap returned an error.
  • ora-00281 : media recovery may not be performed using dispatcher
  • ora-06912 : CMX: write error in datarq
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-13626 : The specified object string is not valid for task string.
  • ora-16034 : FROM parameter is incompatible with MANAGED recovery
  • ora-19031 : XML element or attribute string does not match any in type string.string
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-07759 : slemtr: invalid destination
  • ora-30176 : invalid format code used in the format string
  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-06791 : TLI Driver: poll returned error event
  • ora-07702 : unrecognized device type in archive text
  • ora-17626 : ksfdcre: string file exists
  • ora-02061 : lock table specified list of distributed tables
  • ora-29813 : non-supported object type with associate statement
  • 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.