7 Replies Latest reply on Apr 24, 2017 4:14 PM by 3434325

ORA-13199 error--> Tablespace does not exist

3434325 Apr 18, 2017 5:19 PM

Hi all,

[ This is my first newbie question regarding the creation of my first RDF model in Oracle 12.2.0.1.0. ]

I've been trying to follow the steps in quick start section 1.14 [1] for using semantic data.

So after creating my tablespace and the corresponding semantic network (steps 1-2). I created a user to be able to perform steps 4-5 by doing

CREATE USER rdfuser IDENTIFIED BY <pwd-rdfuser> DEFAULT TABLESPACE <my_tablespace>;

GRANT connect, resource TO rdfuser;

However, when I connect to the newly created user, to perform the creation of the associated model (step 5) , I get an error saying

ORA-13199: Tablespace <my_tablespace> does not exist

What can I do to finish this basic steps for creating an RDF model to be able to load my 727 Mio NQUADS triples?

Thanks in advance for any input or pointer.

Best,

Ghislain

[1] RDF Semantic Graph Overview

1. Re: ORA-13199 error--> Tablespace does not exist

alwu-Oracle Apr 19, 2017 12:21 AM (in response to 3434325)

You are supposed to create a tablespace and plugin the name of your tablespace.

e.g.

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;

Thanks,

Zhe Wu
Like Show 0 Likes(0)

Actions
2. Re: ORA-13199 error--> Tablespace does not exist

3434325 Apr 19, 2017 7:30 AM (in response to alwu-Oracle)

Thanks Zhe!
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.
Like Show 0 Likes(0)

Actions
3. Re: ORA-13199 error--> Tablespace does not exist

3434325 Apr 19, 2017 9:26 AM (in response to alwu-Oracle)

Hi Zhe,
I am still getting the same error ( see below). I guess I am doing something wrong?!
Thanks in advance.
GA
Like Show 0 Likes(0)

Actions
4. Re: ORA-13199 error--> Tablespace does not exist

alwu-Oracle Apr 20, 2017 4:22 PM (in response to 3434325)

Hi GA,

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.

Thanks,

Zhe
Like Show 0 Likes(0)

Actions
5. Re: ORA-13199 error--> Tablespace does not exist

3434325 Apr 24, 2017 8:58 AM (in response to alwu-Oracle)

Hi Zhe,
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.

Best,
GA
Like Show 0 Likes(0)

Actions
6. Re: ORA-13199 error--> Tablespace does not exist

alwu-Oracle Apr 24, 2017 3:49 PM (in response to 3434325)

Hi,

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.

Thanks,

Zhe Wu
Like Show 0 Likes(0)

Actions
7. Re: ORA-13199 error--> Tablespace does not exist

3434325 Apr 24, 2017 4:14 PM (in response to alwu-Oracle)

Hi Zhe,
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!

Thanks.
GA
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.