SQL Developer - Table or View Does Not Exist

Glen_D
Glen_D used Ask the Experts™
on
I insitalled SQL Developer and loving the app but having this issue when trying to run queries against the tables, even by dragging and dropping into the query window - states tables does not exist.  

Permissions - granted all to Public.  My account is logged in as sysdba and used to access the db in developer.  

Any ideas?

Thx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2009

Commented:
1) You should not login as sysdba for schema work. It is only for highly privileged dba work.

2) Sounds like you are logged in as sys into the sys schema and not the owner of the data schema you were working with.

Try select * from schemaname.states

Not sure what schemaname is in your case. You can find it with:

select owner, table_name from dba_tables where table_name = 'STATES';

Top Expert 2009

Commented:
The tags say Oracle 10g but it is posted in Oracle 9.x, which version is this? (not that it really matters for the question)
Top Expert 2009
Commented:
To clarify what I said above.

In Oracle when you login to a given user, that user has a "schema" which is simple a namespace or container. Some other database flavors think if it as an individual "database". In any case, you can always refer to your own objects under the simple names, STATES, for example. But another user who has been granted access to your table would have to use GLEN.STATES to refer to the table. Even a DBA who needs no grants to see the table still needs to refer to it as GLEN.STATES. Only you as GLEN can refer to it as STATES. It is also possible for another user with the right privileges to set their default schema to yours, but that is an uncommon case.

Author

Commented:
Thx...I quit the DBA log an dwent with the user and everything worked.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial