aspose file tools*
The moose likes JDBC and the fly likes SDO_RDF_TRIPLE_S  is a invalid datatype? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SDO_RDF_TRIPLE_S  is a invalid datatype?" Watch "SDO_RDF_TRIPLE_S  is a invalid datatype?" New topic
Author

SDO_RDF_TRIPLE_S is a invalid datatype?

James Jiang
Greenhorn

Joined: Dec 13, 2007
Posts: 24
Hi,all:
when i try to create a table like this: CREATE TABLE test(OID NUMBER, TRIPLE SDO_RDF_TRIPLE_S); in oracle 11g, and it says SDO_RDF_TRIPLE_S is a invalid datatype,but oracle 11g has declared to support RDF.I cann't work it out. Could anyone help me out, Thanks in advance.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
did your create the table space for rdf and the data network associated with the rdf table space first?
James Jiang
Greenhorn

Joined: Dec 13, 2007
Posts: 24
Thank you for your kind reply, Your reply reminds me of something that I have forget doing, so I login the database as a user with DBA Privileges,start SQL*Plus and exexute the following script: MyOracle_Home\md\admin\catsem11i.sql. And it works now.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
you're welcome... glad to know it works
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SDO_RDF_TRIPLE_S is a invalid datatype?