ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
- 2 Answers
- 9143 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-19611: backup piece out of order. Expected string but found string
ORA-16220: no failed transaction found
ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
SQL*Loader-00487: COUNT clause required for collection string
PCC-02417: Illegal type conversion between attribute and host variable
TNS-00204: Started tracing in intlsnr
ORA-19630: end of volume encountered while copying backup piece
PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL
ORA-08317: sllfsk: Error seeking in file.
ORA-07221: slspool: exec error, unable to start spooler program.
ORA-24500: invalid UTF16 mode
ORA-13459: GeoRaster metadata SRS error
Oracle Errors 
