Oracle Text

Below are Oracle Scripts to administer an Oracle's Text Server (starting with 8i it is called InterMedia, 9i called ConText)... feel free to use the scipts listed, all I ask is that you retain the ownership block at the top of each script.

Disclaimer: User assumes all responsibility; please understand the objective of the script and use it accordingly. If you do not see a script for a specific function please let me know via eMail and I can probably 'whip' one up in a matter of minutes...

Script Name	Purpose
all_oco_indexes.sql	Show all ConText Indexes
all_oco_pend_txn.sql	Show all ConText pending transactions
all_oco_policies.sql	Show all ConText policies
all_oco_policy_attr.sql	Show all the indexes for a given policy
all_oco_pref_attr.sql	Show the attributes associated with a policy
all_oco_pref_usage.sql	Show which policies are using a specific preference
all_oco_servers.sql	Show all ConText Servers
all_oco_stop_list.sql	SQL statement to stop all ConText Servers
all_oco_versions.sql	Show all ConText policy versions


	[Home] [Professional] [Vacations] [All About Rick]


	Have a question or comment... please email me at Rick@Kupcunas.com