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 : 24-07-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-40272 : apply rules prohibited for this model mode
  • ora-12651 : Encryption or data integrity algorithm unacceptable
  • ora-01027 : bind variables not allowed for data definition operations
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-28044 : unsupported directory type
  • ora-26096 : transfer size too small for row data (number bytes required)
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-09913 : Malloc of dummy name failed.
  • ora-02251 : subquery not allowed here
  • ora-10371 : disable TQ hint
  • ora-39150 : bad flashback time
  • ora-01514 : error in log specification: no such log
  • ora-31668 : Timeout before worker process string finished initialization.
  • ora-40101 : Data Mining System Error string-string-string
  • ora-13143 : invalid POLYGON window definition
  • ora-24231 : database access descriptor (DAD) string not found
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-02304 : invalid object identifier literal
  • ora-12843 : pdml lock not held properly on the table
  • ora-13037 : SRIDs do not match for the two geometries
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-32344 : cannot create a secondary materialized view with synonym as base table
  • ora-01210 : data file header is media corrupt
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-39085 : cannot update job string for user string
  • ora-13618 : The specified value is not a valid value for procedure argument string.
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-19025 : EXTRACTVALUE returns value of only one node
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • 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.