Activation fails with an ORA-00942: table or view does not exist. (16030)
Activation fails with an ORA-00942: table or view does not exist.
Error received when activating the configuration (sp_ctrl (oradev2:2100)> activate config ksadmin.lst)
"Failed to find object "KSADMIN"."ACTIVEHALT" due to ORA-00942: table or view does not exist."
For Oracle 9i database, O7_DICTIONARY_ACCESSIBILITY is default to false. Activation fails because Shareplex user does not have access to dictionary data.
1. Check to see if the value for O7_DICTIONARY_ACCESSIBILITY is set to false.
2. Grant user access to the Data Dictionary:
For Oracle 8i:
'grant select_catalog_role to splex'
For Oracle 9i:
'grant select any dictionary to splex'
3. Activate Configuration again.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED.