This discussion is archived
12 Replies Latest reply: Nov 22, 2012 4:49 AM by Solomon Yakobson RSS

Table not found but Table data is available

Hulk Newbie
Currently Being Moderated
Hi,

I logged in as SYS.

When placed the below query in sql navigator, no rows found.
select * from dba_objects where object_type='TABLE' and object_name='GREM';

But when placed the below query,rows are retrieved.
select * from grem;

How is it possible?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points