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 : 28-05-2017
ORA-25954

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

  • ora-01513 : invalid current time returned by operating system
  • ora-25019 : too much concurreny
  • ora-30343 : level name is not unique within this dimension
  • ora-01185 : logfile group number string is invalid
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-07241 : slemrd: read error.
  • ora-01234 : cannot end backup of file string - file is in use or recovery
  • ora-02440 : Create as select with referential constraints not allowed
  • ora-00351 : recover-to time invalid
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-19115 : too many context items specified
  • ora-16061 : Log file status has changed
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-10945 : trace name context forever
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-15179 : missing or invalid alias name
  • ora-09919 : Unable to set label of dedicated server
  • ora-24265 : Insufficient privileges for SQL profile operation
  • ora-12429 : label list range exceeded
  • ora-07236 : slemop: open error.
  • ora-39769 : finish is not allowed with an incompletely loaded last row
  • ora-30384 : specified column name does not exist in the attribute
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-27413 : repeat interval is too long
  • ora-12534 : TNS:operation not supported
  • ora-09362 : Windows 3.1 Two-Task driver unable to deallocate context area
  • ora-22619 : all collection elements have already been accessed
  • 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.