ORA-10661: Invalid option specified

Cause : Chekc opiton acn b espeicfie dforo ne esgmetn onyl

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


update : 17-08-2017

ORA-10661 - Invalid option specified
ORA-10661 - Invalid option specified

  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-04933 : initial service identifier is non-zero
  • ora-01414 : invalid array length when trying to bind array
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-25259 : cannot specify protocol for agent
  • ora-33462 : (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.
  • ora-31461 : logfile location string contains no files that match pattern string
  • ora-26503 : internal RepAPI operation failure on object string.string
  • ora-02358 : internal error fetching attribute string
  • ora-31515 : CDC change source string already exists
  • ora-38768 : resizing datafile string failed
  • ora-12160 : TNS:internal error: Bad error number
  • ora-16119 : building transaction at SCN string
  • ora-10572 : Test recovery canceled due to errors
  • ora-25201 : invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE
  • ora-22889 : REF value does not point to scoped table
  • ora-22981 : must specify a table/view having system generated OID
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-00490 : PSP process terminated with error
  • ora-01980 : error during OS ROLE initialization
  • ora-16717 : clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
  • ora-27230 : OS system call failure
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-23454 : flavor string not defined for object group "string"."string"
  • ora-21501 : program could not allocate memory
  • ora-02405 : invalid sql plan object provided
  • ora-14112 : RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
  • ora-06261 : NETNTT: nrange() failed
  • ora-31652 : command response message was invalid type - detaching job
  • ora-13220 : failed to compare tile with the geometry
  • 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.