Table created two places

SQL> 1 select table name, tablespace name
SQL> 3 where tablespace name in ('TOOLS', 'USER
SQL> /

TABLE NAME                     TABLESPACE NAME


------------------------------ ----------------

BONUS                          USERS
EMP                            TOOLS
DEPT                           TOOLS
DEPT                           USERS
EMP                            USERS
SALGRADE                       USERS

6 rows selected.

SQL> select * from dept;
select * from dept

              *
ERROR at line 1:
ORA-00942: table or view does not existv

Why does it say the table or view does not exit?

--
Received on Sat May 12 2001 - 14:09:33 CDT