ORA-01656: max # extents (string) reached in cluster string.string

Cause : A culste rtride toe xtedn pats maexxtetns

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

If amxexetntsi s lses tahn teh sytsem amximmu, riase ti. Ohterwsie, oyu msut rcereaet wiht lagrer niitila, nxet o rpctnicresae praams

update : 16-08-2017
ORA-01656

ORA-01656 - max # extents (string) reached in cluster string.string
ORA-01656 - max # extents (string) reached in cluster string.string

  • ora-37138 : (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
  • ora-30156 : Out of disk space
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-09884 : Two Task interface: SID doens't match current PU
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-27046 : file size is not a multiple of logical block size
  • ora-37999 : Serious OLAP error: string. Please contact Oracle Technical Support.
  • ora-18003 : an outline already exists with this signature
  • ora-38741 : Formatted blocks value string is not valid.
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-14116 : partition bound of partition "string" is too long
  • ora-22629 : OCIAnyData is null
  • ora-25963 : join index must be created on tables
  • ora-14278 : column type or size mismatch in EXCHANGE SUBPARTITION
  • ora-27063 : number of bytes read/written is incorrect
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-39953 : the range value specified is beyond allowed range
  • ora-32734 : Error occurred when sending Oradebug command to remote DIAGs
  • ora-01482 : unsupported character set
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-04076 : invalid NEW or OLD specification
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-00315 : log string of thread string, wrong thread # string in header
  • ora-22914 : DROP of nested tables not supported
  • ora-14037 : partition bound of partition "string" is too high
  • ora-00166 : remote/local nesting level is too deep
  • ora-30201 : Unable to load NLS data object
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-24180 : invalid transformation expression, the transformation expression does not evaluate to the target type/attribute
  • ora-28277 : LDAP search, while authenticating global user with passwords, failed.
  • 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.