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 : 27-04-2017
ORA-12990

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

  • ora-15028 : ASM file 'string' not dropped; currently being accessed
  • ora-16798 : unable to complete terminal recovery on the standby database
  • ora-29363 : plan directive string, string is mandatory and cannot be modified or deleted
  • ora-36873 : (XSTFDSC03) Column type must be specified explicitly.
  • ora-02458 : HASHKEYS must be specified for a HASH CLUSTER
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-07497 : sdpri: cannot create trace file 'string'; errno = string.
  • ora-00372 : file string cannot be modified at this time
  • ora-12074 : invalid memory address
  • ora-19672 : media management software returned invalid file status
  • ora-22865 : more than one column specified
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-06790 : TLI Driver: poll failed
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-24015 : cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
  • ora-13625 : %s is an invalid advisor object type.
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-02755 : osnfsmcre: cannot create chared memory file ?/dbs/ftt_.dbf
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-37144 : (MDQUERY01) string is not a valid metadata object type for MDQUERY.
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-24402 : error occured while creating connections in the pool
  • ora-28120 : driving context already exists
  • ora-04085 : cannot change the value of an OLD reference variable
  • 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.