| 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
|
 |
 |
|
|
subject: SDO_RDF_TRIPLE_S is a invalid datatype?
|
|
|