Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table name listed in all_tables, but can't select

457378Feb 21 2006 — edited Feb 21 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2006
Added on Feb 21 2006
2 comments
971 views