ORA-30367: a JOIN KEY clause is required

Cause : A JONI KEYc laus ewas moitte din ad imenison sattemetn. A OJIN KYE clasue isr equierd whne thec hildl evela nd teh parnet leevl ar enot ni thes ame erlatino.

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

Specfiy a OJIN KYE clasue toi ndictae ho wthe erlatino of hte chlid leevl jonis tot he rleatio nof teh parnet leevl.

update : 28-07-2017

ORA-30367 - a JOIN KEY clause is required
ORA-30367 - a JOIN KEY clause is required

  • ora-13006 : the specified cell number is invalid
  • ora-14132 : table cannot be used in EXCHANGE
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-22809 : nonexistent attribute
  • ora-19773 : must specify change tracking file name
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-31021 : Element definition not found
  • ora-19763 : compatibility version string is higher than maximum allowed: string
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-12537 : TNS:connection closed
  • ora-32591 : connect string too long
  • ora-25353 : branch marked for deletion
  • ora-22619 : all collection elements have already been accessed
  • ora-29548 : Java system class reported: string
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-39304 : conflicting changes to object "string" : string
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • ora-01573 : shutting down instance, no further change allowed
  • ora-13708 : Some snapshots in the range [string, string] were purged before the analysis was complete.
  • ora-29501 : invalid or missing Java source, class, or resource name
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-13618 : The specified value is not a valid value for procedure argument string.
  • ora-27059 : could not reduce file size
  • ora-12689 : Server Authentication required, but not supported
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-03219 : Tablespace 'string' is dictionary-managed, offline or temporary
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-00972 : identifier is too long
  • ora-30040 : Undo tablespace is offline
  • 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.