ORA-01129: user's default or temporary tablespace does not exist

Cause : The user's default or temporary tablespace was dropped.

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

Reassign the default or temporary tablespace.

update : 26-09-2017
ORA-01129

ORA-01129 - user's default or temporary tablespace does not exist
ORA-01129 - user's default or temporary tablespace does not exist

  • ora-24317 : define handle used in a different position
  • ora-29514 : class name contains illegal character
  • ora-02080 : database link is in use
  • ora-07444 : function address string is not readable
  • ora-22615 : attribute is not a collection
  • ora-13287 : can't transform unknown gtype
  • ora-13763 : illegal ranking attribute "string"
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-02462 : Duplicate INDEX option specified
  • ora-01342 : LogMiner can not resume session due to inability of staging checkpointed data
  • ora-13605 : The specified task or object string does not exist for the current user.
  • ora-32054 : lost communication with FMPUTL process
  • ora-23483 : object "string"."string" not allowed in this operation.
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-26049 : Unscoped REF column has non-existent table name.
  • ora-27376 : event condition cannot be NULL
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-22151 : cannot resize non-zero variable-length array to zero elements
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-13836 : invalid attribute value specified
  • ora-13610 : The directive string does not exist for task string.
  • ora-02355 : error opening file: string
  • ora-01175 : data dictionary has more than the string files allowed by the instance
  • ora-19380 : invalid plan filter
  • ora-29372 : identifier string is too long; it must be less than string characters
  • ora-28345 : cannot downgrade because there exists encrypted column
  • ora-13204 : failed to create spatial index table
  • ora-09746 : smscre: shared memory attach address incorrect.
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-26040 : Data block was loaded using the NOLOGGING option
  • 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.