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 : 21-07-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-19738 : cannot find language information for character set: 'string'
  • ora-29963 : missing BINDING keyword
  • ora-02238 : filename lists have different numbers of files
  • ora-09845 : soacon: Archmon unable to open named pipe.
  • ora-22861 : invalid user-defined type
  • ora-37026 : (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
  • ora-14282 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-16808 : unable to resolve the full path name
  • ora-38742 : Flashback log file has incorrect log reset status.
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-26765 : invalid parameter "string" for downstream capture "string"
  • ora-13516 : AWR Operation failed: string
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-01231 : cannot make read write - file string is offline
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-31413 : change set string is currently being advanced
  • ora-08100 : index is not valid - see trace file for diagnostics
  • ora-22869 : depth of type dependency hierarchy exceeds maximum limit
  • ora-32631 : illegal use of objects in MODEL
  • ora-23368 : name string cannot be null or the empty string
  • ora-25426 : remote instance does not support shared dblinks
  • ora-13124 : unable to determine column id for column string
  • ora-00042 : Unknown Service name string
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-00606 : Internal error code
  • ora-30512 : cannot modify string.string more than once in a transaction
  • ora-36642 : (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
  • ora-07273 : sppst: invalid semaphore id.
  • ora-31405 : cannot make changes while change set string is advancing
  • 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.