Simple select query not working - why?

[Guest_imported]

I am stuck and feel like an idiot. I have an account on e03k18 and can run queries against alt_tab_columns but cannot run simple queries like you would expect...

I can't do something like:

select * from it1_ticket where ticket_number = 'xxxxx';

or anything like that, it always comes back with a 942, table or view does not exist... why?

I tried addressing the table like arsr.it1_ticket and that doesn't work either.

What the heck am I doing wrong?

This works:

SQL> select distinct table_name,column_name,data_type from all_tab_columns
2 where table_name like 'IT1%' or table_name like 'CHAR%';

I picked IT1 and CHAR stuff because that seems to have the most meaningfull columns to do queries against.

I just need to run some simple queries, and in the past (and it's been a while) I just say

select * from TABLE_NAME where COLUMN_NAME = 'yadda'

and it works great.

The only thing I can rule out is typo errors, it is a problem with addressing the tables... but why can I address them when searching against all_tab_columns and nothing else?

Darn I am stuck.

 

[fluteplr]

Sounds like a security/permissions issue to me. Are you sure you have select permission on the tables you are trying to select data from.