How to solve Oracle Database Error 1446 (ora-01446)

Oracle Error Code
   ora-01446

Description
   cannot select ROWID from view with DISTINCT, GROUP BY, etc.

Cause
   A SELECT statement attempted to select ROWIDs from a view containing columns derived from functions or expressions. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned.
How to Solve
   Remove ROWID from the view selection clause, then re-execute the statement.
Posts About Oracle Database Error ORA-01449
Laura:
How do you remove the ROWID, ROWID is not part of my select statement?


Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-01346    ORA-01347    ORA-01350    ORA-01446    ORA-01447    ORA-01448    ORA-01449  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares