Table name listed in all_tables, but can't select
457378Feb 21 2006 — edited Feb 21 2006I just installed XE, created a user, logged in as user, and created a table. I couldn't insert a record (error: ORA-00942: table or view does not exist) using SQL Command Line, so I logged in to GUI and can insert a record.
If I look in the list of tables, I find the table:
SQL> select table_name from all_tables where table_name like 'E%';
TABLE_NAME
------------------------------
Employee
However, if I try to select something from the table, I'm told table does not exist:
SQL> select * from Employee;
select * from Employee
*
ERROR at line 1:
ORA-00942: table or view does not exist
Any idea what I'm doing wrong here?
Thanks.
Glenn