Oracle-Text-组件-说明

Oracle相关教程

Oracle Text 组件 说明Oracle Text 组件 说明


一.OracleText 组件说明
在说明之前，我们先用如下SQL 查看一下DB中的组件：
SQL> col comp_id for a15
SQL> col version for a15
SQL> col comp_name for a30
SQL> select comp_id,comp_name,versionfrom dba_registry ;

COMP_ID COMP_NAME VERSION
--------------- ---------------------------------------------
XDB Oracle XML Database 11.2.0.3.0
AMD OLAP Catalog 11.2.0.3.0
EM Oracle Enterprise Manager 11.2.0.3.0
SDO Spatial 11.2.0.3.0
ORDIM Oracle Multimedia 11.2.0.3.0
CONTEXT Oracle Text 11.2.0.3.0
ODM Oracle Data Mining 11.2.0.3.0
EXF Oracle Expression Filter 11.2.0.3.0
RUL Oracle Rules Manager 11.2.0.3.0
OWM Oracle Workspace Manager 11.2.0.3.0
CATALOG Oracle Database Catalog Views 11.2.0.3.0

COMP_ID COMP_NAME VERSION
--------------- ---------------------------------------------
CATPROC Oracle Database Packages and T11.2.0.3.0
ypes

JAVAVM JServer JAVA Virtual Machine 11.2.0.3.0
XML Oracle XDK 11.2.0.3.0
CATJAVA Oracle Database Java Packages 11.2.0.3.0
XOQ Oracle OLAP API 11.2.0.3.0
APS OLAP Analytic Workspace 11.2.0.3.0

17 rows selected.

MOS上的说明：
Oracle 8i/9i/10g/11g 组件（Components） 说明
/tianlesoftware/article/details/5937382

Oracle Text（全文索引） is available for no extra Licensing in all four database editions:Oracle Database Standard Edition One, Oracle Database Standard Edition (SE),Oracle Database Enterprise Edition (EE) and Oracle Database Personal Edition.Oracle Text uses standard SQL to index, search, and analyze text and documentsstored in the Oracle database, in files, and on the Web. Oracle Text canperform linguistic analysis on documents; search text using a variety ofstrategies including keyword searching, boolean operations, pattern matching,mixed thematic queries, HTML/XML section searching, etc. Oracle Text can rendersearch results in various formats including unformatted text, HTML withhighlighting, and original document format. Oracle Text supports multiplelanguages including Japanese, Korean, Traditional and Simplified Chinese.

Oracle Textindexes any document or textual content to add fast, accurate retrieval ofinformation to internet content management applications, e-Business catalogs,news services, job postings, and so on. It can index content stored in filesystems, databases, or on the Web.
--Oracle text（全文检索） 可以把任何文档和文件编入索引，从而是访问更快，更容易检索相关的信息。 Text 的索引可以存储在文件系统，数据库或者Web。

Oracle Text allows text searches to be combined with regular database searches in a singleSQL statement. It can find documents based on their textual content, metadata,or attributes. The Oracle
Text SQL API makes it simple and intuitive to createand maintain Text indexes and run Text searches.

Text 组件使用的用户：CTXSYS/CTXSYS The Oracle T

Oracle相关教程

ext account

二． Oracle Text 组件重建MOS 文档：
Note579601.1Manual installation, deinstallation and verification ofOracle Text 11gR1Note.970473.1Manualinstallation, deinstallation and verification of Oracle Text 11gR2Note.280713.1Manualinstallation, deinstallation of Oracle Text 10gR1 and 10gR2Note.275689.1Manualinstallation, deinstallation of Oracle Text 9.2.0.xNote.150316.1Manualinstallation of Oracle Text version 9.0.1Note.73605.1Installationof Oracle Text version 8.1.x (formally interMedia Text)Note.177233.1Manualdeinstallation of Oracle Text (Intermedia Text)Note.159959.1Howto Install Oracle Text 9.0.1 using Scripts

2.1 Oracle 10g中重建2.1.1 Manualinstallation of Text 10gR1 (10.1.0.x)--安装Text 组件
1. Text dictionary, schema name CTXSYS, iscreated by calling following script from SQL*Plus connected as SYSDBA:
--使用如下脚本。

SQL> connect SYS/password@tns_ as SYSDBASQL> spool text_install.txtSQL> @?/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK
--脚本中各个参数含义：
CTXSYS - is the ctxsys user passwordSYSAUX - is the default tablespace for ctxsysTEMP - is the temporary tablespace for ctxsysLOCK|NOLOCK - ctxsys user account will be locked or not
2. The next step is to install appropriatelanguage-specific default preferences.
--指定默认的安装语言
There is scriptwhich creates language-specific default preferences for every language Oracletext supports in/ctx/admin/defaults directory, such as English(US),Danish(DK), Dutch(NL), Finnish(SF), French(F), German(D), Italian(IT),Portuguese(PT), Spanish(E), and Swedish(S). They are named in the formdrdefXX.sql, where XX is the international license plate code.
To manuallyinstall US default preferences, for example, log into sqlplus as CTXSYS, andrun 'drdefus.sql' as described below:
--如果使用US作为默认语言，执行drdefus.sql.

SQL> connect CTXSYS/password@tns_aliasSQL> @?/ctx/admin/defaults/drdefus.sqlSQL> spool off
注意：
If you haveinstalled Oracle Data Mining (ODM) before Text you will see in thetext_install.txt logfile ORA-955 errors for public synonyms, e.g. dm_svm_build,which can be ignored. We have a dummy package that mimics the API in CTXSYSschema, and we attempt to create public synonyms to it. Now, if ODM has beeninstalled, these public synonym creates fail and the public synonyms point toODM objects, which is what we want.


2.1.2 Text 10gR1 (10.1.0.x) Installation verification--在10gR1中检查Text 的安装1. Check to make sure that all Text objectswere created in CTXSYS schema and correct version is installed。
--确认所有的Text 对象已经安装在CTXSYS用户下。2. Check to make sure that there are not invalid objects for CTXSYS.
--确保没有无效对象。
You should get: "no rows selected& …… 此处隐藏：5435字，全部文档内容请下载后查看。喜欢就下载吧 ……