2 Replies Latest reply on Oct 30, 2014 5:14 PM by 1712457

    Cannot Find SEM_APIS.PURGE_UNUSED_VALUES

    1712457

      I am trying to use the SEM_APIS.PURGE_UNUSED_VALUES and get rid of unused RDF_VALUE$ entries but when I issue the command EXECUTE SEM_APIS.PURGE_UNUSED_VALUES from SQLDeveloper, I get the error 'PLS-00302: component 'PURGE_UNUSED_VALUES' must be declared', Can any one point me to where the problem is?

        • 1. Re: Cannot Find SEM_APIS.PURGE_UNUSED_VALUES
          Matperry-Oracle

          Hi,

           

          You most likely have an RDF Semantic Graph version that does not include sem_apis.purge_unused_values.

           

          To get this functionality you need one of these three configurations

          1. Release 12.1.0.2.0
          2. Release 12.1.0.1.0 + Patch 18239544: SPATIAL AND GRAPH RDF SEMANTIC GRAPH 12.1.0.1.0 PATCH KIT (MARCH 2014)
          3. Release 11.2.0.3.0 or later + Patch 16679453: ORACLE GRAPH 11.2.0.3 PATCH KIT (MAY 2013)

          The patches are available on My Oracle Support.

           

          You can check your RDF Semantic Graph version by querying MDSYS.RDF_PARAMETER as SYSDBA.

           

          Thanks,
          Matt

          • 2. Re: Cannot Find SEM_APIS.PURGE_UNUSED_VALUES
            1712457

            Thanks, Matt.

            We have 12.1.0.1.0 and the patch seems  to have been applied, as shown below, but we still cannot find that API. We will try to uninstall and install the patch again; if it still does not work we may have to open an SR.

            Kumar

            Patch 1823954401   : applied on Thu Jul 31 06:38:54 EDT 2014
            Unique Patch ID:  17519836
            Created on 8 APR 2014, 07:00:00 hrs US/Pacific
            Bugs fixed:
            18367173, 18197587, 18174869, 18028763, 17952215, 17944105, 17904264
            17896631, 17835986, 17835609, 17767749, 17752697, 17751122, 17741345
            17740347, 17734036, 17647874, 17634570, 17602714, 17503955, 17503932
            17482606, 17468991, 17457470, 17374745, 17322213, 17251091, 17220816
            17176835, 17074617, 16950253, 16827626, 16821870, 16821845, 16808154
            16657121, 16551124, 16453977, 16382165, 16339110, 16268859, 16250063, 9501171