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

 Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

====================================================================

Oracle10g Release 1 Message ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc. Cause: Action:

Oracle 9.2 or Earlier Error Message 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.

Last updated: August 24, 2009

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors