ORA-02461: Inappropriate use of the INDEX option

Cause : Thsi otpio niso nl yvaild ofr onn ahshc lutser.s

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

Don ots peicfyt hi sopiton.

update : 24-07-2017
ORA-02461

ORA-02461 - Inappropriate use of the INDEX option
ORA-02461 - Inappropriate use of the INDEX option

  • ora-24003 : Queue table index string inconsistent with queue table string
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-06401 : NETCMN: invalid driver designator
  • ora-13438 : GeoRaster metadata pyramid type error
  • ora-16074 : ARCH processes must be active
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-12437 : invalid policy option: string
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-09770 : pws_look_up: translation failure.
  • ora-14068 : TABLESPACE and TABLESPACE_NUMBER may not be both specified
  • ora-24507 : invalid combination of character set ids
  • ora-36405 : (XSSPROP05) Property ignored for object workspace object:
  • ora-07656 : slsprom:$GETDVI failure
  • ora-14039 : partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-12335 : database (link name string) is not open
  • ora-39076 : cannot delete job string for user string
  • ora-39030 : invalid file type string
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-07630 : smpdal: $DELTVA failure
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-10906 : Unable to extend segment after insert direct load
  • ora-01490 : invalid ANALYZE command
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-04069 : cannot drop or replace a library with table dependents
  • ora-19609 : %s is from different backup set: stamp string count string
  • ora-19000 : missing RELATIONAL keyword
  • ora-29324 : SET COMPATIBILITY release string format is wrong
  • ora-32124 : Illegal attribute passed
  • ora-26673 : duplicate column name string
  • ora-28277 : LDAP search, while authenticating global user with passwords, 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.