ORA-29822: selectivity cannot be specified for the type of object

Cause : sUret irdet osaosicta eeseltcviti yiwhti dnxeo rniedtxpysew ihhci son tlaolew d.

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

pScefi y aavil dpoitno.

update : 29-04-2017
ORA-29822

ORA-29822 - selectivity cannot be specified for the type of object
ORA-29822 - selectivity cannot be specified for the type of object

  • ora-26506 : null global context
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-12821 : invalid value for INSTANCES
  • ora-30931 : Element 'string' cannot contain mixed text
  • ora-01495 : specified chain row table not found
  • ora-16808 : unable to resolve the full path name
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-08106 : cannot create journal table string.string
  • ora-13857 : Invalid module name
  • ora-31484 : source database version must be at least 9.2.0.6 or greater
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-19901 : database needs more recovery to create new incarnation
  • ora-02278 : duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
  • ora-00315 : log string of thread string, wrong thread # string in header
  • ora-24337 : statement handle not prepared
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-38441 : System could not derive the list of STORED and INDEXED attributes.
  • ora-02774 : Invalid request list latch time out value
  • ora-06603 : LU6.2 Driver: Error allocating memory
  • ora-30558 : internal error [string] in function based index
  • ora-02085 : database link string connects to string
  • ora-13524 : error encountered while retrieving baseline information
  • ora-01168 : physical block size string does not match size string of other members
  • ora-13331 : invalid LRS segment
  • ora-27211 : Failed to load Media Management Library
  • ora-28233 : double encryption not supported
  • ora-23324 : error string, while creating deferror entry at "string" with error string
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."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.