Using oracle splex user to run splex_add_trigger on a new installation of shareplex fails with "ORA-904 table or view does not exit"
Oracle splex user does not have the right permission to query against system tables such as sys.user$, sys.obj$, etc. This happens because system account does not have the right permission to grant splex user with all the needed permissions.
1. Recommend option: run ora_setup and make sure all grant statements execute successfully.
If any grant statements fail, manually run those grant statements in sqlplus
2. run splex_add_trigger using Oracle sys account
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center