2 Replies Latest reply on Oct 12, 2017 8:59 AM by 3274437

    Cleaning remain data from RDF

    3274437

      Dear all,

       

      I have no semantic model left which I checked with query

       

      SELECT * FROM MDSYS.SEM_MODEL$;
      

       

      However if I query the dba_segments table of MDSYS:

       

      select segment_name, round(bytes/1024/1024) MB, segment_type
      from dba_segments
      where tablespace_name = 'SIG_RI'
      and OWNER = 'MDSYS'
      order by MB desc; 
      

       

      I see that I sill have a lot of tables that uses a lot of space:

       

      NAMEMBTYPE
      RDF$BDM3D_30D12C2AE1B01_A4  7119    TABLE
      DR$RDF_V$TEXT_IDX$I5552TABLE
      RDF$TLM3D_30D12C2AE1B01_A45019TABLE
      RDF$TLM39_2F0B077A994F7_A44785TABLE
      RDF$TLM3A_2F0B0124D2ED0_A44762TABLE
      RDFX_313961TABLE
      RDF$BSM3D_30D12C2AE1B01_A43400TABLE
      RDF_VAL_NAMETYLITLNG_IDX3119INDEX
      RDF$TVM39_2F0B097BB95B1_A42942TABLE
      RDF$TVM3D_2F80C50FF664E_A42909TABLE
      RDF_VALUE$1880TABLE
      RDF$TVM51_3997FA44A7359_A41600TABLE
      RDF$TLM31_2EC56AC154BCA_A41600TABLE
      DR$RDF_V$TEXT_IDX$X1555INDEX
      RDF$BDM39_2F0B077A994F7_A41544TABLE
      RDF$BDM3A_2F0B0124D2ED0_A41534TABLE
      C_PK_VID1280INDEX
      SYS_IOT_TOP_1877511248INDEX
      SYS_LOB0000187753C00002$$692LOBSEGMENT
      RDF$BSM39_2F0B077A994F7_A4520TABLE
      RDF$BSM3A_2F0B0124D2ED0_A4517TABLE
      RDF$BDM31_2EC56AC154BCA_A4364TABLE
      SYS_LOB0000184620C00010$$104LOBSEGMENT
      RDF$BSM31_2EC56AC154BCA_A437TABLE
      RDF_LNK_SCPM_IDX8INDEX PARTITION
      RDF_LNK_CPSM_IDX8INDEX PARTITION
      SYS_LOB0000187748C00006$$1LOBSEGMENT

       

      So, I wonder how can I eliminate the unnecessary data in MDSYS. Which tables can I drop? 

       

      Thanks in advance,

      Elisa.