ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
Answers were Sorted based on User's Feedback
Answer / geetanjali pandey
This error may when localization is not able to retrieve the
country from location of organization , while creating
location of an organization address field is entered in this
country field should be filled that the location belongs to
which country , this is one of the reason.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / guest
Cause: LEVEL, PRIOR, or ROWNUM is being specified at illegal
location.
Action: Remove LEVEL, PRIOR, or ROWNUM.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 6 No |
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
ORA-02170: FREELIST GROUPS storage option not allowed
QSM-02031: materialized view cannot support any type of query rewrite
ORA-31498: description and remove_description cannot both be specified
DRG-12438: document table release failed
ORA-28043: invalid bind credentials for DB-OID connection
SQL*Loader-00966: Error number disabling all triggers on table string
ORA-19766: missing CHANGE keyword
LPX-00602: Invalid child element '~1S' of element '~2S'.
ORA-38606: FI support threshold not between [0, 1]
ORA-01241: an external cache has died
RMAN-06280: Report of obsolete backups and copies