You are supposed to create a tablespace and plugin the name of your tablespace.
create bigfile tablespace myts
datafile '?/dbs/myts.dat' size 512M reuse autoextend on next 512M maxsize unlimited
EXTENT MANAGEMENT LOCAL
segment space management auto;
CREATE USER rdfuser IDENTIFIED BY <pwd-rdfuser> DEFAULT TABLESPACE myts;
I'll check your suggestion. Just to point out that I did something similar in step 1 as it is mentioned in the Quick start.
CREATE TABLESPACE mytbs
DATAFILE 'mytbs.dat' SIZE 1024M REUSE
AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED
SEGMENT SPACE MANAGEMENT AUTO;
I'ill give a trial to your suggestion.
This looks wrong. "OPOCE_TPL" somehow is gone. Are you using a PDB? Was tablespace OPOCE_TPL created in the PDB? If so, please create the tablespace and initialize the semantic network in the same PDB.
Not sure to understand what is the meaning of PDB.
What is happening is that when connected as SYSTEM, I can create the semantic model, but I can't do it when I change to a normal user.
Now, when I see the owner of tbspace OPOCE_TPL, I want to change the owner.
Regarding your question, yes "OPOCE_TPL" is there.
IMHO, It's somehow not easy to just follow the get started tutorial for using semantic model.
Any pointers or samples that work using sem model is more than welcome.
Sounds like you are not using CDB/PDB.
Can you please run the following command as SYS? After this, please run the create semantic model command.
alter user rdfuser default tablespace OPOCE_TPL quota unlimited on OPOCE_TPL;
Let's find out together what is the best way to improve the get started tutorial.
Someone helps me finding the error. In fact, there is missing the following statement in the documentation after granting connect to <rdfuser>.
alter user <rdfuser> quota unlimited on <tblspace>;
Now, it works!