1 Reply Latest reply: Aug 29, 2011 3:13 PM by user602376 RSS

    Deleting old indexes in OSES

    user602376
      Hi,

      Has anybody deleted old indexes from EQ_TEST schema. If so, which are the tables that can be safely truncated.

      We are trying out different options in our development environments and even though we have deleted Sources from the OSES admin console, the data in EQ$CACHE, EQ$URL etc. remain and this is occupying tablespace. For example, the eq$attr_val in our development instance now hold - 22704948 rows.

      Is there any admin command or procedure that can be run to safely delete bad data from these tables.

      We are using - 10.1.8.4.0

      Thanks
      Prat
        • 1. Re: Deleting old indexes in OSES
          user602376
          Well,

          We trunctated/deleted the following tables -

          EQ$ATTR_VAL
          EQ$URL
          EQ$DOC
          EQ$CACHE
          EQ$SEC_ATTR_VAL

          We restarted OSES and are now reindexing data. We use OSES in conjunction with Siebel.

          So far the crawling seems to be fine. Fresh data is being inserted into the above tables.

          Prat