ORA-12901: default temporary tablespace must be of TEMPORARY type

Cause : ina lcoalyl mnaagde dtaabsae,d efualtt emoprayr tbalepsac emuts b eTEPMORRAY ytpe

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

noen

update : 24-05-2017
ORA-12901

ORA-12901 - default temporary tablespace must be of TEMPORARY type
ORA-12901 - default temporary tablespace must be of TEMPORARY type

  • ora-26062 : Can not continue from previous errors.
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-19372 : invalid update condition
  • ora-13855 : Tracing for service (module/action) string on instance string is already enabled
  • ora-22868 : table with LOBs contains segments in different tablespaces
  • ora-17621 : failed to register the memory with Oracle Disk Manager library
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-02329 : column of datatype string cannot be unique or a primary key
  • ora-37008 : (AWLISTALL06) number writers
  • ora-13455 : GeoRaster metadata TRS error
  • ora-01883 : overlap was disabled during a region transition
  • ora-32838 : exceeded maximum number of properties
  • ora-31044 : Top-level prefix length string exceeds maximum string
  • ora-01921 : role name 'string' conflicts with another user or role name
  • ora-14019 : partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
  • ora-19627 : cannot read backup pieces during control file application
  • ora-07226 : rtneco: unable to get terminal mode.
  • ora-07449 : sc: usnewlock failed.
  • ora-24505 : cannot change character set id on the handle
  • ora-38724 : Invalid option to the FLASHBACK DATABASE command.
  • ora-09756 : osnpns: no port in the name server.
  • ora-14288 : index is not partitioned by Composite Range method
  • ora-26007 : invalid value for SETID or OID column
  • ora-32126 : Cannot perform operations on a null REF
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-24270 : a row already exists in the string table for these parameters
  • ora-30934 : 'string' (string node) cannot be inserted in parent 'string' (string node)
  • ora-01955 : DEFAULT ROLE 'string' not granted to user
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-24387 : Invalid attach driver
  • 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.