Dictionary: DBA_TAB_PRIV

From: <atlguy01_at_hotmail.com>
Date: Fri, 22 Feb 2002 06:21:20 GMT
Message-ID: <3c75e339.12683657_at_news.atl.bellsouth.net>

I am studying my SYBEX OCP, ORACLE 8I SQL and PL SQL book.  I am recently installed Personal Oracle 8I on WIN 98, and am trying to run the following SQL....

SQL> SELECT grantee,privilege
  2 FROM dba_tab_privs
  3 WHERE owner='myschema' AND table_name='myobject';   FROM dba_tab_privs

       *
ERROR at line 2:
ORA-00942: table or view does not exist

Any ideals what is causing this?

I gotta admit... ORACLE seems to be VERY COMPLEX... and I am wondering can i achieve my DBA on my own. Atually.... I am beginning to re-think this, and instead.. pursue a MCSD certification in Visual Basic, which I DO have a grasp of.

Thanks...

SQL> select * from V$VERSION
  2 /

BANNER

---

Oracle8i Personal Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production Received on Fri Feb 22 2002 - 07:21:20 CET