This content has been marked as final. Show 3 replies
Did you try
DROP TABLE RDF_NAMESPACE$;
i want to delete only one namespace, not all....and i'm not sure, if i schould delete this table manually
Deleting a namespace will have to be done by deleting it directly from the table where it is stored, which is the rdf_namespace$ table in the mdsys schema. For example:
connect mdsys/<mdsys password>
delete from rdf_namespace$ where namespace_name = '............';
Please note that the namespaces stored in this table are not used by any of Oracle's operations. This table is merely a convenience for the user, and a similar table can be created in the user's schema, which is likely to be much more convenient than storing it in the mdsys schema. Going forward that is the approach we recommend, as future versions of the product might not include the rdf_tablespace$ table in the mdsys schema (nor the associated add_namespace() API).