tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities
Share this page:

Oracle/PLSQL: ORA-01446

Learn the cause and how to resolve the ORA-01446 error message in Oracle.

Description

When you encounter an ORA-01446 error, the following error message will appear:

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

Cause

You tried to create a view that included a ROWID in the SELECT statement as well as a clause such as DISTINCT Clause or 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.