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 : 20-08-2017
ORA-29928

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

  • ora-01176 : data dictionary has more than the string files allowed by the controlfie
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-19632 : file name not found in control file
  • ora-13826 : empty SQL profile not allowed for create or update SQL profile
  • ora-07271 : spwat: invalid oracle process number.
  • ora-38765 : Flashed back database cannot be opened read-only.
  • ora-25244 : dequeue index key not found, QUEUE string, rowid string
  • ora-36862 : (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid.
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-30970 : option not supported for XML Index
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-25261 : JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation
  • ora-28554 : pass-through SQL: out of cursors
  • ora-00077 : dump string is not valid
  • ora-15065 : hash collision for diskgroup names 'string' and 'string'
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
  • ora-08277 : Cannot set environment variable
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-06752 : TLI: error in signal setup
  • ora-01649 : operation not allowed with a backup control file
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-00480 : LCK* process terminated with error
  • ora-10373 : parallel query server kill event
  • ora-19105 : invalid XQueryX: expected text node - got string
  • ora-19701 : device name exceeds maximum length of string
  • ora-13262 : geometry column string does not exist in table string
  • 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.