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 : 20-08-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-15046 : ASM file name 'string' is not in single-file creation form
  • ora-22981 : must specify a table/view having system generated OID
  • ora-09883 : Two Task interface: oratab file does not exist
  • ora-30493 : The percentile value should be a number between 0 and 1.
  • ora-28235 : algorithm not available
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-02402 : PLAN_TABLE not found
  • ora-12444 : policy already applied to table
  • ora-19527 : physical standby redo log must be renamed
  • ora-19651 : cannot apply offline-range record to datafile string: SCN mismatch
  • ora-09315 : sql2tt: two-task error translating ORACLE_EXECUTABLE
  • ora-23475 : key column string must be sent and compared
  • ora-21706 : duration does not exist or is invalid
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-14327 : Some index [sub]partitions could not be rebuilt
  • ora-24236 : source text is empty
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-06264 : NETNTT: data protocol error
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • ora-29275 : partial multibyte character
  • ora-08106 : cannot create journal table string.string
  • ora-32836 : database user string must be granted role string
  • ora-24806 : LOB form mismatch
  • ora-30490 : Ambiguous expression in GROUP BY ROLLUP or CUBE list
  • ora-02037 : uninitialized speed bind storage
  • ora-10372 : parallel query server kill event proc
  • ora-09757 : osnipn: port allocation failure.
  • ora-03124 : two-task internal error
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • 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.