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 : 27-05-2017
ORA-12911

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

  • ora-07826 : sspscm: SYS$GETDVIW failure
  • ora-31117 : Table "string"."string" is not resource metadata enabled
  • ora-01186 : file string failed verification tests
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-13366 : invalid combination of interior exterior rings
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-06772 : TLI Driver: error sending command
  • ora-06752 : TLI: error in signal setup
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-02809 : Jump buffer not valid
  • ora-38453 : ExpFilter index should be created in the same schema as the base table.
  • ora-24239 : object could not be invalidated
  • ora-06592 : CASE not found while executing CASE statement
  • ora-29879 : cannot create multiple domain indexes on a column list using same indextype
  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-06430 : ssaio: Seals do not match
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-23312 : not the masterdef according to string
  • ora-12822 : duplicate option in PARALLEL clause
  • ora-02061 : lock table specified list of distributed tables
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-32761 : Turn off Temp LOB Ref Count Feature
  • ora-12561 : TNS:unknown error
  • ora-15171 : invalid syntax in the alias path after 'string'
  • ora-38774 : cannot disable media recovery - flashback database is enabled
  • ora-28358 : improper set key syntax
  • ora-30969 : invalid syntax for PARAMETERS
  • ora-07278 : splon: ops$username exceeds buffer length.
  • ora-12824 : INSTANCES DEFAULT may not be specified here
  • 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.