ORA-22975: cannot create a PRIMARY KEY-based REF to this object view

Cause : Th eobejctv ie wspceifeid ni teh MKAE_ERF ufncitond oe sno thaev aP RIAMRYK EYb-asde ojbec tidnetiifer .A RPIMRAY EKY-abse dRE Fcannotb e rceaetd ofr uscha veiw.

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

Spceif yano bjcet ivewt ha tha sa RPIMRAY EKY-abse dobejcti detnifeir ni teh MKAE_ERF ufnciton.

update : 30-04-2017
ORA-22975

ORA-22975 - cannot create a PRIMARY KEY-based REF to this object view
ORA-22975 - cannot create a PRIMARY KEY-based REF to this object view

  • ora-10970 : backout event for bug 2133357
  • ora-01308 : initialization parameter utl_file_dir is not set
  • ora-01479 : last character in the buffer is not Null
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-13854 : Tracing for service(module/action) string on instance string is not enabled
  • ora-38857 : cannot mark redo thread string as enabled
  • ora-12569 : TNS:packet checksum failure
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-24024 : Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]
  • ora-19669 : proxy copy functions cannot be run on DISK channel
  • ora-29529 : invalid function or method call string in trigger string
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-17505 : ksfdrsz:string Failed to resize file to size string blocks
  • ora-01579 : write error occurred during recovery
  • ora-01161 : database name string in file header does not match given name of string
  • ora-16623 : stale DRC UID sequence number detected
  • ora-19729 : File string is not the initial version of the plugged in datafile
  • ora-07717 : sksaalo: error allocating memory
  • ora-14151 : invalid table partitioning method
  • ora-06734 : TLI Driver: cannot connect
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-19625 : error identifying file string
  • ora-32412 : encrypted column "string" not allowed in the materialized view log
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-30086 : interval year-month result not allowed for datetime subtraction
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-37105 : (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
  • ora-31084 : error while creating table "string"."string" for element "string"
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-06308 : IPA: No more connections available
  • 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.