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 : 29-06-2017

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

  • ora-07718 : sksafre: error freeing memory
  • ora-01596 : cannot specify system in string parameter
  • ora-23326 : object group "string"."string" is quiesced
  • ora-32143 : Environment not specified
  • ora-02795 : Request list is empty
  • ora-02087 : object locked by another process in same transaction
  • ora-26694 : error while enqueueing into queue string.string
  • ora-01361 : global name mismatch
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-38428 : too many attributes selected for indexing
  • ora-15123 : ASM file name 'string' contains an invalid incarnation number
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-22620 : buffer size too small to hold the value
  • ora-06528 : Error executing PL/SQL profiler
  • ora-28055 : the password will expire within string days
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-16078 : media recovery disabled
  • ora-23303 : application raised generic exception during deferred RPC
  • ora-27068 : I/O buffer is not aligned properly
  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-40204 : model string already exists
  • ora-12995 : no columns in partially dropped state
  • ora-28507 : error in data dictionary view string
  • ora-32612 : invalid use of FOR loop
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-30351 : query rewrite does not currently support this expression
  • ora-30370 : set operators are not supported in this context
  • ora-25008 : no implicit conversion to LOB datatype in instead-of trigger
  • ora-27122 : unable to protect memory
  • 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.