Thanks marist89,

I'm able to see the table name from ALL_TABLES view, if I simply do a select from sqlplus, so that should mean I have the SELECT privilege on ALL_TABLES:

select table_name from all_tables where table_name='ABC.XXX';

So I don't know what's wrong.