Re: Table created two places

From: Sathish B <SathishRani_at_home.com>
Date: Sat, 12 May 2001 19:16:18 GMT
Message-ID: <6 fL6.8456$R5.1029479@news1.rdc1.va.home.com>

Do a
SQL > Select table name from user tables ; Does dept list under this . you may not have select previleges on the table if you are not the owner of the table .

HTH
- Sathish
  "Rusty Fadgen" <rfadgen_at_cfl.rr.com> wrote in message news:NTfL6.203508$fs3.34483203_at_typhoon.tampabay.rr.com...

  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:16:18 CDT