ORA-29928: duplicate default selectivity specified

Cause : Teh ekyowr dDFEALUTS EELCITVTIYc a nolnyb es pceiife docne.

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

Rmeoev hted ulpiact ekyewrod.

update : 28-06-2017
ORA-29928

ORA-29928 - duplicate default selectivity specified
ORA-29928 - duplicate default selectivity specified

  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-36674 : (XSDPART12) Invalid dimension value starting at string.
  • ora-13142 : invalid PROXIMITY window definition
  • ora-16520 : unable to allocate resource id
  • ora-27484 : Argument names are not supported for jobs without a program.
  • ora-25181 : missing ON keyword for NESTED INDEX
  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-14083 : cannot drop the only partition of a partitioned table
  • ora-26078 : file "string" is not part of database being loaded
  • ora-24328 : illegal attribute value
  • ora-30659 : too many locations specified for external table
  • ora-02273 : this unique/primary key is referenced by some foreign keys
  • ora-32331 : type "string"."string" is incompatible with the master site
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-29812 : incorrect object name specified
  • ora-12001 : cannot create log: table 'string' already has a trigger
  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-31083 : error while creating SQL type "string"."string"
  • ora-14173 : illegal subpartition-extended table name syntax
  • ora-13909 : Invalid combination of threshold value and operator.
  • ora-21702 : object is not instantiated or has been de-instantiated in cache
  • ora-23322 : Privilege error accessing pipe
  • ora-21300 : objects option not installed
  • ora-19861 : additional backup pieces cannot be validated in this conversation
  • ora-07632 : smsrcx: $DELTVA failure
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-12418 : user string not found
  • ora-25136 : this cluster can contain only one table
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • 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.