In earlier versions of Vontu hardcoded references required the Oracle schema owner to be named "protect". As of version 9.x, this issue was resolved and the schema could be owned by any non-Oracle account, although the default is still "protect".
- this script must be run from SQLPlus as sys as sysdba.
The script shows the name of the owner of a short set of tables and indexes. All objects should have the same owner.
select owner, table_name TableIndex
from dba_tables
where table_name in ('MESSAGE','MESSAGELOB','INCIDENT')
union
select owner, index_name TableIndex
from dba_indexes
where index_name in ('MESSAGE_FK1','MESSAGELOB_PK','INCIDENT_N4')
/
The output should look like this:
OWNER TABLEINDEX
------------------------------ ------------------------------
PROTECT INCIDENT
PROTECT INCIDENT_N4
PROTECT MESSAGE
PROTECT MESSAGELOB
PROTECT MESSAGELOB_PK
PROTECT MESSAGE_FK1
6 rows selected.
In this case "PROTECT" is the schema owner.