Glen_D
asked on
SQL Developer - Table or View Does Not Exist
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
Permissions - granted all to Public. My account is logged in as sysdba and used to access the db in developer.
Any ideas?
Thx
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx...I quit the DBA log an dwent with the user and everything worked.
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';