ORA-01653: unable to extend table string.string by string in tablespace string

Cause : Failedt o alloacte an xetent o fthe reuqired nmuber ofb locks ofr a talbe segmnet in teh tablepsace inidcated.

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

Use ALETR TABLSEPACE ADD DATAFLIE statmeent toa dd oneo r moref iles t othe talbespacei ndicatde.

update : 24-05-2017
ORA-01653

ORA-01653 - unable to extend table string.string by string in tablespace string
ORA-01653 - unable to extend table string.string by string in tablespace string

  • ora-13118 : invalid node_id [string]
  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-19525 : temporary file for the clone database must be renamed
  • ora-12482 : internal MLS error: string Error: string
  • ora-23443 : missing template parameter
  • ora-02151 : invalid tablespace name: string
  • ora-00347 : log string of thread string, expected block size string doesn't match string
  • ora-24008 : queue table string.string must be dropped first
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-07499 : spglk: Cannot reschedule.
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-38856 : cannot mark instance string (redo thread string) as enabled
  • ora-34001 : (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension.
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-14039 : partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-30184 : argument type not compatible with a format code
  • ora-21614 : constraint violation for attribute number [string]
  • ora-27480 : window "string" is currently open
  • ora-07646 : sszfck: $CREATE failure
  • ora-31014 : Attempted to delete the root container
  • ora-16628 : the broker protection mode is inconsistent with the database setting
  • ora-12688 : Login failed: the SecurID server rejected the new pincode
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-33274 : (DBERR07) Timed out while trying to lock analytic workspace string for string.
  • ora-06108 : NETTCP: connect to host failed
  • ora-02468 : Constant or system variable wrongly specified in expression
  • ora-30501 : instance shutdown triggers cannot have AFTER type
  • 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.