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-14011: names assigned to resulting partitions must be distinct
QSM-02028: group by CUBE
DRG-50865: failed to append to collection
IMG-00520: invalid value for numberOfBands
ORA-02072: distributed database network protocol mismatch
TNS-00536: Connection entered inappropriate state
ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
DRG-12803: invalid text datatype
RMAN-06082: datafilecopy tag string is ambiguous
ORA-07432: unable to perform nested sleep
RMAN-06742: platform name 'string' longer than number
ORA-38493: feature not enabled : Expression Filter index