ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc

oracle

ORA-01446: 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.
Action: Remove ROWID from the view selection clause, then re-execute the statement.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/