ORA-12910: cannot specify temporary tablespace as default tablespace

Cause : atetmp ttoa ssgin atepmorray atblsepaec t obea uesr' sdeaful ttalbesapce

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

asisgna premaenntt abelspcae ot b eth edeaful ttalbesapce

update : 24-05-2017
ORA-12910

ORA-12910 - cannot specify temporary tablespace as default tablespace
ORA-12910 - cannot specify temporary tablespace as default tablespace

  • ora-27452 : %s is an invalid name for a database object.
  • ora-36832 : (XSLMGEN02) View token cannot be greater than 4000 bytes
  • ora-06765 : TLI Driver: error awaiting orderly release
  • ora-38777 : database must not be started in any other instance.
  • ora-31512 : name cannot contain double quotation marks
  • ora-02054 : transaction string in-doubt
  • ora-13623 : The recommendation string is not valid for task string.
  • ora-00342 : archived log does not have expected resetlogs SCN string
  • ora-02098 : error parsing index-table reference (:I)
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-01221 : data file string is not the same file to a background process
  • ora-02714 : osnpwr: message send failure
  • ora-00283 : recovery session canceled due to errors
  • ora-19904 : test recovery not allowed for datafile string
  • ora-40211 : algorithm name string is invalid
  • ora-13300 : single point transform error
  • ora-36637 : (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.
  • ora-12733 : regular expression too long
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-01192 : must have at least one enabled thread
  • ora-14110 : partitioning column may not be of type ROWID
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-28665 : table and partition must have same compression attribute
  • ora-01804 : failure to initialize timezone information
  • ora-01554 : out of transaction slots in transaction tables
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-29972 : user does not have privilege to change/ create registration
  • 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.