With 11g, you probably have to use a relational to RDF mapping tool like D2R. It is quite straightforward to materialize triples into an N-TRIPLE file, once you have a proper mapping. After that, you can bulk load the N-TRIPLE file into Oracle Database.
If you upgrade to 12c, then you can leverage the native RDB2RDF (Direct Mapping & R2RML) support in Oracle.
We are considering to upgrade to 12c, so its likely that we are going to deal with a 12c database at the end. Decision has to be made soon so I'll come back with more clues for it. I presume that the easiest way is to use the tool RDB2RDF, doesn't it?. I'd try to avoid to dump the entire database in a file to load it up straight away in RDF.
thank you for your reply.
1 person found this helpful
That is correct. BTW, you may want to take a step-by-step approach. Start with a couple of tables and turn them into RDF. Once you get more comfortable with how things work, you can scale up to a whole schema or multiple schemas.
Hope it helps,