Skip to Main Content

Oracle Database Discussions

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!

ORA-00942: table or view does not exist

hphanjra-JavaNetJan 4 2007 — edited Jan 4 2007
i do have grants select, insert, update, delete on this view tst_fl_ld but still
getting ora 942. i can also desc tst_fl_ld


SQL> create materialized view log on tst_fl_ld with rowid
;
  2  create materialized view log on tst_fl_ld with rowid
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> desc tst_fl_ld 
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USER_ID                                            NUMBER
 SERVER_ID                                          NUMBER
 SERVER_NAME                                        VARCHAR2(20)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2007
Added on Jan 4 2007
7 comments
3,595 views