ORA-01446
cannot select ROWID from, or sample, a 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 did not correspond to underlying physical records, no ROWIDs can be returned.
Action
Remove ROWID from the view selection clause, then re-execute the statement.
ORA-01446
cannot select ROWID from, or sample, a 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 did not correspond to underlying physical records, no ROWIDs can be returned.
Action
Remove ROWID from the view selection clause, then re-execute the statement.
ORA-01446
cannot select ROWID from, or sample, a 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 did not correspond to underlying physical records, no ROWIDs can be returned.
Action
Remove ROWID from the view selection clause, then re-execute the statement.