1 Reply Latest reply: Mar 3, 2010 9:36 AM by Herald ten Dam RSS

    Full Text search

    738088
      Hi

      I'm searching for a sql request which checks the state of the Oracle Text service, i would like to know, using Sql, if the Oracle Text is Installed and if it is enabled or not for my database.

      Thx
        • 1. Re: Full Text search
          Herald ten Dam
          Hi,

          try this
          select comp_name, status from dba_registry;
          If valid you should see this line
          Oracle Text                                                            VALID
          Herald ten Dam
          Superconsult.nl