ORA-12990: duplicate option specified

Cause : Dulpictae potino sepciifedi n tsatmeen.t

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

Reomvet hed upilcaet otpio nan dreusbmti satteemnt.

update : 29-06-2017
ORA-12990

ORA-12990 - duplicate option specified
ORA-12990 - duplicate option specified

  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-19108 : WHITESPACE keyword expected
  • ora-38725 : specified name "string" does not match actual "string"
  • ora-13628 : Insufficient privileges to access the task belonging to the specified user
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • ora-09952 : scgcmn: lk_open_convert unexpected return: open failed
  • ora-07573 : slkhst: could not perform host operation
  • ora-29900 : operator binding does not exist
  • ora-37031 : (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.
  • ora-15204 : database version string is incompatible with diskgroup string
  • ora-01519 : error while processing file 'string' near line string
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • ora-13830 : SQL profile with category string already exists for this SQL statement
  • ora-16582 : could not edit instance specific property
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-32831 : timed out trying to acquire administration lock
  • ora-38466 : user does not have privileges to CREATE/MODIFY expressions
  • ora-02443 : Cannot drop constraint - nonexistent constraint
  • ora-12045 : invalid ALTER MATERIALIZED VIEW LOG option
  • ora-16533 : inconsistent Data Guard broker state
  • ora-10701 : Dump direct loader index keys
  • ora-12056 : invalid REFRESH method
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-24430 : Null values for sqltext and key were specified.
  • ora-07743 : slemop: incorrect error file attributes
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-01058 : internal New Upi interface error
  • ora-30731 : scope constraint not allowed on nested table column when the nested table is being created
  • 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.