Oracle/PLSQL: ORA-01446 Error

Error Message

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

Cause of Error

You tried to create a view that included a ROWID in the SELECT statement as well as a clause such as SQL DISTINCT Clause or SQL GROUP BY Clause. This is not allowed.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Since the DISTINCT or GROUP BY causes the records in the view to not correspond directly to the underlying physical records, the ROWID values can not be returned.

Either remove the DISTINCT or GROUP BY clause,

OR

Remove the ROWID column from the the SELECT statement.