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

Cause : Failed ot allocaet an extnet of th erequire dnumber fo blocksf or inde xsegmenti n the tbalespacei ndicate.d

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

Use ALTRE TABLESAPCE ADD ADTAFILE tsatementt o add oen or mor efiles t othe tabelspace idnicated.

update : 29-06-2017
ORA-01683

ORA-01683 - unable to extend index string.string partition string by string in tablespace string
ORA-01683 - unable to extend index string.string partition string by string in tablespace string

  • ora-23403 : refresh group "string"."string" already exists
  • ora-33450 : (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.
  • ora-30467 : internal data for filter number string is inconsistent
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-01599 : failed to acquire rollback segment (string), cache space is full
  • ora-28522 : error initializing heterogeneous capabilities
  • ora-15151 : missing or invalid version number for rolling upgrade or downgrade
  • ora-37999 : Serious OLAP error: string. Please contact Oracle Technical Support.
  • ora-32002 : cannot create SPFILE already being used by the instance
  • ora-24758 : not attached to the requested transaction
  • ora-01544 : cannot drop system rollback segment
  • ora-02063 : preceding stringstring from stringstring
  • ora-02816 : Unable to kill a process
  • ora-16785 : the database is not in ARCHIVELOG mode
  • ora-32321 : REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE
  • ora-38429 : invalid datatype for a stored attribute: string
  • ora-30493 : The percentile value should be a number between 0 and 1.
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-13261 : geometry table string does not exist
  • ora-27067 : size of I/O buffer is invalid
  • ora-01075 : you are currently logged on
  • ora-32828 : Messaging Gateway agent must be running
  • ora-31460 : logfile location string is not an existing directory
  • ora-24408 : could not generate unique server group name
  • ora-15059 : invalid device type for ASM disk
  • ora-30129 : invalid function argument received
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-28591 : agent control utility: unable to access parameter file
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • 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.