ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
- 2 Answers
- 9610 Views
- I also Faced
- E-Mail Answers
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-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags
QSM-01071: a lossy join in materialized view, string, from table, string, not found in query
LFI-00116: Unable to close file in operation string.
ORA-00274: illegal recovery option string
ORA-16097: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
ORA-19684: block media recovery failed because database is suspended
PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables
ORA-06902: CMX: cannot attach to cmx subsystem
QSM-00753: the specified value string is out of the acceptable range of string to string for parameter string
SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)
TNS-00074: * status - get statistics from the process_name
ORA-23457: invalid flavor ID string
Oracle Errors 
