2 Replies Latest reply on Oct 12, 2017 8:59 AM by 3274437

Cleaning remain data from RDF

3274437 Oct 11, 2017 12:54 PM

Dear all,

I have no semantic model left which I checked with query

SELECT * FROM MDSYS.SEM_MODEL$;

However if I query the dba_segments table of MDSYS:

select segment_name, round(bytes/1024/1024) MB, segment_type
from dba_segments
where tablespace_name = 'SIG_RI'
and OWNER = 'MDSYS'
order by MB desc;

I see that I sill have a lot of tables that uses a lot of space:

So, I wonder how can I eliminate the unnecessary data in MDSYS. Which tables can I drop?

Thanks in advance,

Elisa.

1. Re: Cleaning remain data from RDF

Matperry-Oracle Oct 11, 2017 6:11 PM (in response to 3274437)

Hi Elisa,

If your semantic network is empty, the easiest way to cleanup is to drop and re-create the network as a DBA.

exec sem_apis.drop_sem_network();
exec sem_apis.create_sem_network('YOUR_TABLESPACE');

Those RDF$... tables are transient tables from failed bulk_load operations. They can be dropped.
The RDFX_31 table can also be dropped.

Thanks,
Matt
Like Show 0 Likes(0)

Actions
2. Re: Cleaning remain data from RDF

3274437 Oct 12, 2017 8:59 AM (in response to 3274437)

Hi Matt,

Thanks a lot for the help! I will try that!

Elisa.
Like Show 0 Likes(0)

Actions

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