This discussion is archived
7 Replies Latest reply: Oct 2, 2012 3:11 AM by dwhittin RSS

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

True Thomas Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points