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 : 24-06-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-16402 : ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
  • ora-19557 : device error, device type: string, device name: string
  • ora-16661 : the standby database needs to be reinstated
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-12623 : TNS:operation is illegal in this state
  • ora-07392 : sftcls: fclose error, unable to close text file.
  • ora-07625 : smsget: $MGBLSC failure
  • ora-01912 : ROW keyword expected
  • ora-01070 : Using an old version of Oracle for the server
  • ora-24320 : unable to initialize a mutex
  • ora-32831 : timed out trying to acquire administration lock
  • ora-07448 : ssarena: maximum number of shared arenas exceeded.
  • ora-01204 : file number is string rather than string - wrong file
  • ora-16152 : standby database is in 'no-data-loss' protected mode
  • ora-24341 : bad mode specified
  • ora-31406 : change source string is referenced by a change set
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-12545 : Connect failed because target host or object does not exist
  • ora-01186 : file string failed verification tests
  • ora-26718 : transaction limit reached
  • ora-16764 : redo transport service to a standby database is offline
  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-08316 : sllfsk: Error seeking in file.
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-16093 : dependent archive log destination is not LGWR-enabled
  • ora-00321 : log string of thread string, cannot update log file header
  • ora-14194 : only one subpartition may be rebuilt
  • ora-06811 : TLI Driver: could not set the IPX network number at init
  • ora-09817 : Write to audit file 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.