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 : 23-06-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-01751 : Invalid dump undo option
  • ora-32412 : encrypted column "string" not allowed in the materialized view log
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-32823 : subscriber exists for queue string and destination string
  • ora-16613 : initialization in progress for database
  • ora-23468 : missing string string
  • ora-30034 : Undo tablespace cannot be specified as temporary tablespace
  • ora-06021 : NETASY: connect failed
  • ora-09772 : osnpmetbrkmsg: message from host had incorrect message type
  • ora-06007 : NETASY: bad dialogue format
  • ora-16182 : Internal error on internal channel during remote archival
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-07713 : sksamtd: could not mount archival device (SYS$MOUNT failure)
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-36914 : (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and it's ancestor.
  • ora-15083 : failed to communicate with ASMB background process
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-36710 : (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
  • ora-30106 : reserved for future use
  • ora-02032 : clustered tables cannot be used before the cluster index is built
  • ora-07562 : sldext: extension must be 3 characters
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-29552 : verification warning: string
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-24173 : nested query not supported for rule condition
  • ora-29262 : bad URL
  • ora-26715 : time limit reached
  • ora-13604 : The specified parameter string cannot be fetched as a SQL table.
  • ora-22060 : argument [string] is an invalid or uninitialized number
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • 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.