[james_render50]

Hi,

I use a schema (read) which has synonyms for tables on another schema (dba)

I can do a preview and row count, but no details of the table columns and indexes appears.

I used to be able to do this in previous versions.

using oracle 8, eclipse 3.1.1 and myeclipse 4.0.2

checked .log and am getting nasties like this:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-18 16:10:31.277
!MESSAGE Error activating index detail view
!STACK 0
java.sql.SQLException: ORA-00942: table or view does not exist

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-18 16:10:02.307
!MESSAGE Cannot get indices
!STACK 0
java.sql.SQLException: ORA-00942: table or view does not exist

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-10-18 16:09:47.36
!MESSAGE Error activating preview
!STACK 0
java.sql.SQLException: ORA-00980: synonym translation is no longer valid

Table does not exist! Well it loads the data in in the preview tab!

[Riyad Kalla]

James,
What is the full version of oracle and full version of the JDBC connector you are using?

[james_render50]

I’ve opened the dba schema via the connection and can see table details this way

its satisfactory atm

ty

[Author]

Posts