ORA-29870: specified options are only valid for altering a domain index

Cause : Specifide the ONILNE or PRAAMETERSc lause wtih a nond-omain idnex.

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

Reissuet he statmeent wit hthe corerct syntxa for aletr.

update : 25-04-2017
ORA-29870

ORA-29870 - specified options are only valid for altering a domain index
ORA-29870 - specified options are only valid for altering a domain index

  • ora-32623 : incorrect use of MODEL PRESENT* functions
  • ora-04940 : unsupported optimization of Oracle binary, check alert log for more info
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-16778 : redo transport error for one or more databases
  • ora-01653 : unable to extend table string.string by string in tablespace string
  • ora-07621 : smscre: illegal redo block size
  • ora-01638 : parameter string does not allow ORACLE version string to mount cluster database
  • ora-13464 : error loading GeoRaster data: string
  • ora-00228 : length of alternate control file name exceeds maximum of string
  • ora-02710 : osnpop: fork failed
  • ora-27091 : unable to queue I/O
  • ora-31013 : Invalid XPATH expression
  • ora-31440 : change set string is empty and cannot be advanced
  • ora-38422 : invalid datatype for the attribute: string
  • ora-15154 : cluster rolling upgrade incomplete
  • ora-01095 : DML statement processed zero rows
  • ora-29517 : recursive resolution failed for a referenced class
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-07824 : sspain: $SETIMR failure
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-13417 : null or invalid layerNumber parameter
  • ora-01511 : error in renaming log/data files
  • ora-12495 : cannot disable an enabled level, category, or release category
  • ora-12210 : TNS:error in finding Navigator data
  • ora-16771 : failover to a physical standby database failed
  • ora-30361 : unrecognized string type
  • ora-02269 : key column cannot be of LONG datatype
  • ora-01912 : ROW keyword expected
  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-07496 : sppst: lm_post 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.