7 Replies Latest reply: Oct 2, 2012 5:11 AM by Dwhittin-Oracle RSS

    SQL Developer 3.1 EA3:   ORA-01446: cannot select ROWID . . .

    True Thomas
      I'm running into a problem in 3.1 EA3 that I did not see in 3.0 (Oracle IDE     3.0.04.34). Both Installations are 64 bit using 64 bit Java under Windows 7 x64 SP1.


      When from either the "Connections" or "Schema" window I open some views and select the "Data" tab I the following messages:

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

      twice. Other views give:

      ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
      ORA-02063: preceding line from HSDEVL

      All views that show the error retrieve the data via a dblink to another oracle instance, although not all views using the dblink show an error.

      Has anyone else seen this change? Is there anything I can do to get it fixed.

      Thanks.

      Tom True

      P