3 Replies Latest reply on Jun 27, 2007 8:48 PM by Mannamal-Oracle

    How to remove namespace

    556961
      Hello,
      i have again a little problem, i don't know, how to remove a namespace. I can insert namespaces using SDO_RDF.ADD_NAMESPACES, bit i can't find something like SDO_RDF.DEL_NAMESPACES..any suggestions?
        • 1. Re: How to remove namespace
          479833
          Did you try
          DROP TABLE RDF_NAMESPACE$;
          Emine
          • 2. Re: How to remove namespace
            556961
            i want to delete only one namespace, not all....and i'm not sure, if i schould delete this table manually
            • 3. Re: How to remove namespace
              Mannamal-Oracle
              Hi,

              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).

              Melli