ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

Cause : Selfe-videtn.

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

Remoev thed upliacte sepcifiaction.

update : 23-07-2017

ORA-02259 - duplicate UNIQUE/PRIMARY KEY specifications
ORA-02259 - duplicate UNIQUE/PRIMARY KEY specifications

  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-00268 : specified log file does not exist 'string'
  • ora-14157 : invalid subpartition name
  • ora-32310 : object materialized views must select from an object table
  • ora-26032 : index string.string loading aborted after string keys
  • ora-08435 : PICTURE MASK missing the leading sign when SIGN IS LEADING specified
  • ora-06019 : NETASY: invalid login (connect) string
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-23462 : flavor string in use at site string
  • ora-36970 : (XSRELTBL12) workspace object must be a self-relation.
  • ora-27069 : attempt to do I/O beyond the range of the file
  • ora-02160 : index-organized table can not contain columns of type LONG
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-14273 : lower-bound partition must be specified first
  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-29534 : referenced object string.string could not be resolved
  • ora-12725 : unmatched parentheses in regular expression
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-39041 : Filter "string" either identifies all object types or no object types.
  • ora-07628 : smsfre: sga not mapped
  • ora-01201 : file string header failed to write correctly
  • ora-38735 : Wrong log number string in flashback log file header.
  • ora-26761 : Standby Redo Logs not available for real time mining
  • ora-26000 : partition load specified but table string is not partitioned
  • ora-16540 : invalid argument
  • ora-00250 : archiver not started
  • ora-16219 : This database is not preparing to switch over.
  • ora-12701 : CREATE DATABASE character set is not known
  • 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.