ORA-01654: unable to extend index string.string by string in tablespace string

Cause : Faile dto alolcate na extetn of teh requried nubmer ofb locksf or ani ndex esgmenti n thet ablesapce inidcated.

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

Use ATLER TALBESPAC EADD DTAAFILEs tatemnet to dad oneo r mor efilest o thet ablesapce inidcated.

update : 16-08-2017
ORA-01654

ORA-01654 - unable to extend index string.string by string in tablespace string
ORA-01654 - unable to extend index string.string by string in tablespace string

  • ora-19279 : XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
  • ora-23612 : unable to find tablespace "string"
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-39310 : call to DBMS_SCHEMA_COPY.CLEAN_FAILED_CLONE is not legal
  • ora-27461 : The value for attribute string is too large.
  • ora-26725 : cannot downgrade apply handlers
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-12593 : TNS:no registered connection
  • ora-01332 : internal Logminer Dictionary error
  • ora-39782 : Direct path prepare is not allowed after another context loading the same table has ended
  • ora-39095 : Dump file space has been exhausted: Unable to allocate string bytes
  • ora-32165 : Cannot get XA environment
  • ora-34260 : (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead.
  • ora-31671 : Worker process string had an unhandled exception.
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-31210 : DBMS_LDAP: PL/SQL - LDAP get_dn error.
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-30743 : "string" is not an object view
  • ora-24356 : internal error while converting from to COBOL display type.
  • ora-19815 : WARNING: string of string bytes is string%% used, and has string remaining bytes available.
  • ora-25187 : specified exceptions table form incorrect
  • ora-29312 : changes by release string cannot be used by release string, type: string
  • ora-06108 : NETTCP: connect to host failed
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-19100 : PASSING or RETURNING keyword expected
  • ora-25243 : CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
  • ora-16748 : resource guard encountered errors during database open
  • ora-29746 : Cluster Synchronization Service is being shut down.
  • 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.