| illegal JOIN KEY clause | |
| Cause: | A JOIN KEY clause was specified that did not conform to certain requirements. A JOIN KEY clause connecting a child level with its non-immediate ancestor level is allowed only when that child level and its ancestor level satisfy the following conditions:
1. The immediate parent of the child level must be a skip level. 2. The child level cannot be a skip level. 3. The ancestor level must be a non-skip level. 4. The ancestor level must be the nearest non-skip level to the child level in the hierarchy. |
| Action: | Modify the JOIN KEY clause so that it satisfies the conditions mentioned above. |
| ORA-30399 | |
Custom Search
|
| More Oracle errors | |
| ORA-29391 | string and string must be mandatory to create a mandatory plan directive |
| ORA-09322 | slpdtb: unable to convert packed decimal to binary |
| PGU-39400 | IT read %4li bytes from string |
| ORA-15092 | I/O request size string is not a multiple of logical block size string |
| ORA-24066 | invalid privilege specified |
| ORA-07266 | sppst: invalid process number passed to sppst. |
| AMD-00148 | Workspace "string" is not currently open. No update done. |
| RMAN-12016 | using channel string |
| ORA-31453 | invalid value string for parameter, expecting: Y, N, or NULL |
| PLS-00605 | set operators are not yet supported as an argument to a MULTISET operator |
| OCI-31163 | element or attribute "string" has invalid attribute value "string" (should be "string") |
| ORA-31491 | could not add logfile to LogMiner session |
| ORA-08189 | cannot flashback the table because row movement is not enabled |
| PGU-35011 | no environment rows for statement string, string string: rc string |
| ORA-15161 | invalid SYS_CLUSTER_PROPERTIES parameter |
| RMAN-06547 | SYSTEM tablespace cannot be excluded from whole database backup |
| SQL*Loader-00527 | OCI return status: no data |
| ORA-29655 | USING clause is incompatible with its supertype |
| ORA-22905 | cannot access rows from a non-nested table item |
| ORA-16703 | cannot set property while the database is enabled |
| TOP 20 Oracle errors | |
| ORA-12504 | TNS:listener was not given the SERVICE_NAME in CONNECT_DATA |
| RMAN-20079 | full resync from primary database is not done |
| ORA-14411 | The DDL cannot be run concurrently with other DDLs |
| ORA-14760 | ADD PARTITION is not permitted on Interval partitioned objects |
| ORA-10877 | error signaled in parallel recovery slave string |
| ORA-32701 | Hang detected |
| ORA-00838 | Specified value of MEMORY_TARGET is too small, needs to be at least stringM |
| ORA-16665 | timeout waiting for the result from a database |
| ORA-16957 | SQL Analyze time limit interrupt |
| ORA-16664 | unable to receive the result from a database |
| RMAN-08132 | WARNING: cannot update recovery area reclaimable file list |
| ORA-00000 | normal, successful completion |
| ORA-16766 | Redo Apply is stopped |
| ORA-00837 | Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET |
| RMAN-08137 | WARNING: archived log not deleted as it is still needed |
| DIA-48122 | error with opening the ADR block file [string] [string] |
| ORA-47988 | password should contain at least one numeric and one alphabetic character |
| IMP-00057 | Warning: Dump file may not contain data of all partitions of this table |
| ORA-00001 | unique constraint (string.string) violated |
| ORA-55508 | Invalid input to Flashback Transaction Backout |
| Your own TOP 20 Oracle errors | |
| ORA-30398 | illegal JOIN KEY clause |