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)