|
From: Colin B. <col...@bi...> - 2004-04-01 11:26:17
|
On Thu, Mar 18, 2004 at 04:24:30PM -0700, John David Lilly wrote: > I had Squirrel 1.1 working perfectly against my Oracle 8.1.7, using the > system user. Today I am getting an "ORA-00942: table or view does not > exist" error upon login. > > The left pane is blank except for the top level node, and if I try to > refresh I get the error again. I can still run SQL statements against > the tables without a problem (so the connection works), I just can't see > the view in the left pane. > > I ran catalog.sql and my first export of the DB yesterday, I can't think > how that would mess things up. I'm guessing whatever commands Squirrel > runs to populate that left pane must have been affected by my changes. > > I googled the ORA error but found nothing pointing to a solution. > Any insights or suggestions on how to fix would be greatly appreciated. > -John > Sounds like you are missing metadata tables from the database. SQuirreL uses standard JDBC calls to retrieve the list of tables. The driver maps this to the appropriate action for the DBMS, usually queries over metadata tables of some form. I don't know how this is done in Oracle. I don't know what the catalog.sql script that you ran does does but it may have either removed the metadata tables or removed your authority to access them. -- Colin Bell http://squirrel-sql.sf.net |
