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 : 24-06-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-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-31523 : could not find change source string for CDC change set string
  • ora-30726 : cannot specify referenced column list here
  • ora-22950 : cannot ORDER objects without MAP or ORDER method
  • ora-36618 : (XSAGMODDIM00) workspace object is not a valid model for AGGMAP ADD.
  • ora-07820 : sspscn: SYS$CRELNM failure
  • ora-28558 : HS_FDS_CONNECT_STRING undefined for non-Oracle system
  • ora-19264 : XQ0044 - invalid namespace in attribute constructors
  • ora-13345 : a compound polygon geometry has fewer than five coordinates
  • ora-28237 : seed length too short
  • ora-23386 : replication parallel push cannot create slave processes
  • ora-30339 : illegal dimension attribute name
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-32588 : supplemental logging attribute string exists
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-10922 : Temporary tablespace group is empty
  • ora-15158 : rolling upgrade prevented by string
  • ora-07755 : slemcf: fseek before read failure
  • ora-13621 : The task_or object string is marked as a template and cannot perform the requested operation.
  • ora-27032 : failed to obtain file size limit
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-37005 : (AWLISTALL03) number readers
  • ora-31107 : Action failed as resource "string" is locked by name lock
  • ora-12200 : TNS:could not allocate memory
  • ora-02718 : osnprs: reset protocol error
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-09830 : snyAddPort: failed to perform a remote procedure call.
  • ora-19722 : datafile string is an incorrect version
  • ora-16076 : unknown standby database destination
  • 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.