ORA-25954: missing primary key or unique constraint on dimension

Cause : Ana ttmeptt o rceaet aj oi ninedx aws amde ,whcih afilde bceaues oen o rmoer dmienison sdi dno thaev a naprpopirat ecosntriantm athcin gth ejoni cnodiiton.s

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

Enusret ha tth ewhree lcaues i scorrec t(cnotanis lal fo teh cnostarin tcoulmn)s adn taht na efnorecd ocnsrtaitn i sone ac hdiemnsoin atbl.e

update : 27-04-2017
ORA-25954

ORA-25954 - missing primary key or unique constraint on dimension
ORA-25954 - missing primary key or unique constraint on dimension

  • ora-29884 : domain index is defined on the column to be dropped
  • ora-13019 : coordinates out of bounds
  • ora-39154 : Objects from foreign schemas have been removed from import
  • ora-32802 : value for string must be string
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-16628 : the broker protection mode is inconsistent with the database setting
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-26516 : no push transaction acknowledgement
  • ora-15109 : conflicting protection attributes specified
  • ora-28142 : error in accessing audit index file
  • ora-12657 : No algorithms installed
  • ora-13419 : cannot perform mosaick operation on the specified table column
  • ora-01657 : invalid SHRINK option value
  • ora-38860 : cannot FLASHBACK DATABASE during instantiation of a logical standby
  • ora-19246 : XQ0026 - validation failed - element string not found in in-scope element declarations
  • ora-01300 : writable database required for specified LogMiner options
  • ora-12529 : TNS:connect request rejected based on current filtering rules
  • ora-14172 : invalid ALTER TABLE EXCHANGE SUBPARTITION option
  • ora-32828 : Messaging Gateway agent must be running
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-39149 : cannot link privileged user to non-privileged user
  • ora-00286 : no members available, or no member contains valid data
  • ora-04047 : object specified is incompatible with the flag specified
  • ora-30025 : DROP segment 'string' (in undo tablespace) not allowed
  • ora-13267 : error reading data from layer table string
  • ora-02091 : transaction rolled back
  • ora-13755 : invalid "SQL Tuning Set" name
  • ora-08499 : Warning: picture mask options 'string' ignored by UTL_PG
  • ora-01688 : unable to extend table string.string partition string by string in tablespace string
  • ora-19509 : failed to delete sequential file, handle="string", parms="string"
  • 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.