Hello,
I have installed a docker that contains Oracle database 12c R2 from the docker store (https://store.docker.com/images/oracle-database-enterprise-edition ).
Although I enjoy the user-friendliness of the docker-ized version of oracle database, I am not sure if semantic features are enabled.
I can log in using sys user as sysdba, create table and tablespaces but I cannot use the sem_api package. For example, when I try to create a semantic network
using the command (EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');) I get the following error:
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "MDSYS.RDF_APIS", line 1
ORA-06512: at line 1
I have already created the respective tablespace in a previous step.
It seems like a permission issue but since I used sys user with sysdba permissions, it made me think that something is not right with the sem_apis installation.
But the output of the "desc sem_apis" command seems OK as i get a list of the description of semantic functions and procedures.
On the other hand, I am able to execute scripts like this one: @$ORACLE_HOME/md/admin/catsem.sql with no errors.
The docker instructions mention explicitly that database options and patching is not supported. I am wondering if any of these limitations are disabling (directly or indirectly) the semantic support
or I am just missing something else. I think that partitioning is disabled in this version and I read that it could affect the functionality of the semantic features. However, I would expect a different kind of error in this case.
I would like to confirm that docker supports Spatial and Graph features, so that I can proceed to a native installation if this is not the case.
Thank you and best regards,
Dina