ORA-24295: max key length (string) for sorted hash cluster exceeded

Cause : Sorte dhash lcuster shave amaximmu key isze

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

none

update : 26-09-2017
ORA-24295

ORA-24295 - max key length (string) for sorted hash cluster exceeded
ORA-24295 - max key length (string) for sorted hash cluster exceeded

  • ora-15054 : disk "string" does not exist in diskgroup "string"
  • ora-16748 : resource guard encountered errors during database open
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-16541 : site is not enabled
  • ora-30739 : cannot drop a table that has subtables
  • ora-22055 : unknown sign flag value [string]
  • ora-09701 : scnfy: maximum number of processes exceeded
  • ora-32053 : operation not supported
  • ora-13506 : operation failed due to invalid snapshot range (string, string)
  • ora-01224 : group number in header string does not match GROUP string
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-23385 : replication parallel push string argument not valid
  • ora-32592 : all columns in log group can not be no log columns
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-01281 : SCN range specified is invalid
  • ora-33014 : (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-01599 : failed to acquire rollback segment (string), cache space is full
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-36815 : (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.
  • ora-13362 : disjoint sub-element in a compound polygon
  • ora-19816 : WARNING: Files may exist in string that are not known to database.
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-29324 : SET COMPATIBILITY release string format is wrong
  • ora-19956 : database should have no offline immediate datafiles
  • ora-31211 : DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
  • ora-29342 : user string does not exist in the database
  • 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.