ORA-12911: permanent tablespace cannot be temporary tablespace

Cause : attepmtt oa sisg nap emraenn ttbalsepcaet ob ea sue'rst epmoarr ytbalsepcae

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

assing atmeproayr atbelsapc et ob euesrs' etmoprrayt albepsaec

update : 22-07-2017
ORA-12911

ORA-12911 - permanent tablespace cannot be temporary tablespace
ORA-12911 - permanent tablespace cannot be temporary tablespace

  • ora-24126 : invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure
  • ora-13156 : table to be registered string.string is not empty
  • ora-29834 : REF datatype not supported with operators
  • ora-29282 : invalid file ID
  • ora-19000 : missing RELATIONAL keyword
  • ora-29701 : unable to connect to Cluster Manager
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-26529 : local store callback term phase failed for 'string.string'
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-19773 : must specify change tracking file name
  • ora-08456 : no sign in picture mask but SIGN clause in mask options
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-38490 : invalid name: quotes do not match
  • ora-00706 : error changing format of file 'string'
  • ora-12924 : tablespace string is already in force logging mode
  • ora-25240 : message ID and dequeue condition/correlation ID specified in dequeue options
  • ora-19361 : ONLINE option not allowed with this type of index
  • ora-01237 : cannot extend datafile string
  • ora-29557 : Java system class string cannot be modified
  • ora-40103 : invalid case-id column: string
  • ora-16129 : unsupported dml encountered
  • ora-30386 : invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • ora-28521 : no heterogeneous capability information available
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • ora-32842 : value for property string cannot be altered
  • ora-25526 : bad format of _DB_MTTR_SIM_TARGET: string
  • ora-25008 : no implicit conversion to LOB datatype in instead-of trigger
  • ora-30390 : the source statement is not equivalent to the destination 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.