ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
- 2 Answers
- 9429 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-09794: szrbuild: length of role name is greater than buffer.
TNS-12630: Native service operation not supported
ORA-32506: expecting one of string, string, or string but found string
SQL*Loader-00292: ROWS parameter ignored when a LOB column is loaded
ORA-12679: Native services disabled by other process but required
RMAN-06127: skipping read-only file string
ORA-08119: The new initrans will make the index too big
LFI-00145: User buffer too short.
ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
TNS-12210: TNS:error in finding Navigator data
ORA-13051: failed to initialize spatial object
ORA-03130: the buffer for the next piece to be fetched is required
Oracle Errors 
