ORA-22873: primary key not specified for primary key based object table

Cause : Ana ttmeptt o rceaet ap riamryk eyb asde ojbec ttalbe iwthuot psecfiyign ap riamryk ey

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

Spceif ya rpimray eky nad ertr yth eopreatoin

update : 23-04-2017

ORA-22873 - primary key not specified for primary key based object table
ORA-22873 - primary key not specified for primary key based object table

  • ora-31662 : metadata transform name can not be defaulted
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-26732 : invalid file group string privilege
  • ora-16114 : applying DDL transaction with commit SCN string
  • ora-23477 : unable to alter propagation mode for object group "string"."string"
  • ora-16104 : invalid Logical Standby option requested
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-31533 : only one change set (string) is allowed in change source
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-01271 : Unable to create new file name for file string
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-06433 : ssaio: LSEEK error, unable to seek to requested block.
  • ora-01302 : dictionary build options missing or incorrect
  • ora-00450 : background process 'string' did not start
  • ora-15033 : disk 'string' belongs to diskgroup "string"
  • ora-39705 : component 'string' not found in registry
  • ora-26010 : Column string in table string is NOT NULL and is not being loaded
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-19665 : size string in file header does not match actual file size of string
  • ora-23380 : propagation mode "string" is not valid
  • ora-16533 : inconsistent Data Guard broker state
  • ora-33305 : (DBVALID06) Note: Record number was allocated but not used. This can result in wasted space. (PS number)
  • ora-06904 : CMX: no transport address available for remote application
  • ora-08231 : smscre: unable to attach to SGA
  • ora-02819 : Write failed
  • ora-12652 : String truncated
  • ora-29270 : too many open HTTP requests
  • ora-37181 : expected exactly string columns for dimension string, got 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.