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 |
KUP-04083: no directory object specified in LOBFILE clause for column string
SQL*Loader-00265: Unable to get default character set name.
O2U-00209: Attribute or function name to be translated was not found
ORA-29966: The only binding of an operator cannot be dropped
TNS-12671: Shared server: adapter failed to save context
SQL*Loader-00806: unknown record format specified for data file
ORA-16082: logical standby is not initialized correctly
ORA-38475: The attribute set and the associated ADT are out of sync.
ORA-02379: profile string already exists
DRG-11711: too much data for term string
ORA-07534: scginq: $getlki unexpected return on lockid string
ORA-06549: PL/SQL: failed to dynamically open shared object (DLL): string