i'm using oracle 11g database installed and configured by someone else. kindly let know how to i verify whether oracle text search component is installed or not.
do i have an option to install OTS alone on-top of existing installed files? if so, how do i proceed.
You can check dba_registry to verify if Oracle Text component is installed or not.
SQL> select comp_name, version, status from dba_registry where comp_id='CTX';
Oracle inventory output will show you if Oracle Text software has been installed on your Oracle_Home destination.