Re: Indexing with interMedia

Once you have it set up you can test it with this

create table quick_clob (
 quick_id number primary key,
 text clob
);

insert into quick_clob
  ( quick_id, text )
 values
  ( 1, 'The cat sat on the mat' );

insert into quick_clob
  ( quick_id, text )
 values
  ( 2, 'The quick brown fox jumped over the lazy dog' );

commit;

create index quick_clob_idx on quick_clob ( text )  indextype is ctxsys.context;

SELECT
 score(20),
 text
FROM
 quick_clob
WHERE CONTAINS
 (text, 'near((quick, dog), 6)' ,20) > 0;

drop table quick_clob ;

There are lots of examples in the documentation, list of books

• Text or
• Text Application Developer's Guide

and also in the directories listed in the previous post.

"Snid" <snid_at_snider.sno> wrote in message news:bik1t7$dhf$1_at_bunyip.cc.uq.edu.au...
| Try having a look at the files in the following directories that are in
your
| oracle home
|
| /ord/im/admin
| /ctx/
|
| There is a script in one of the above directories or in the $ORACLE_HOME
| location, that I can't happen to find :( , that tells you everything below
| but in more detail. Note, the following installs Oracle Text, formely
known
| as intermedia, which just allows advanced plain text searching. To
actually
| index pdf documents and other stuff I think you need to set up intermedia
| and also some stuff called inso filters maybe?
|
| There is also an Oracle document that I found a long time ago called "
| Secret Internal Oracle Intermedia Document" that explains a lot more and I
| found this in metalink.
|
| How I set Oracle Text manually for 9i.
|
| -- Create a tablespace for it first
|
| create tablespace drsys
| EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
| SEGMENT SPACE MANAGEMENT AUTO
| DATAFILE '/u01/oradata/DBNAME/drsys.dbf'
| SIZE 8 M REUSE
| AUTOEXTEND ON NEXT 8 M
| MAXSIZE 512 M
| ;
|
| -- The parameters in order are the password, default tablespace and
| temporary tablespace
| -- The following script creates the ctxsys user with appropriate
| tablespaces.
| -- For 9.2.0 as well
| @?/ctx/admin/dr0csys THE_PASSWORD drsys temp;
|
| -- connect as ctxsys user and run the below script depending of whether
you
| are installing
| -- to 9i or 8i Make sure you change the parameter to oracle home
|
| connect ctxsys/PASSWORD
| -- @?/ctx/admin/dr0inst <$ORACLE_HOME>/ctx/lib/libctxx9.so;
| @?/ctx/admin/dr0inst /c01/app/oracle/product/9.2.0/ctx/lib/libctxx9.so;
|
| -- run this script for the appropriate language that you want, eg the last
| two
| -- letters of the script are for the uk, they could be others such as US.
|
| @?/ctx/admin/defaults/drdefuk;
|
|
|
|
|
|
| "Robert Vabo" <rvabo_at_msn.com> wrote in message
| news:3f4ce366_at_news.wineasy.se...
| | I know I am a newbee to Oracle but still I ask my question and hope some
| of
| | you can help me in the right direction.
| |
| | I have a database table that contains a BLOB field that contains
documents
| | of different types. PDF,TXT,TIF etc. I want to index the content of the
| | field so that I can do a free text search in the document.
| |
| | Some of you mention interMedia, and then my question is : How do you set
| up
| | interMedia ? I have read a lot of documentation on the net
| (otn.oracle.com)
| | but I have not found a document that tells me :
| | How do you install interMedia (I have installed it from the CD but when
I
| | start it and log on to my oracle service and want to create an Index it
| | tells me : Oracle interMedia was not installed with this
database.Install
| | Oracle ... )
| | How do you set up interMedia to index the field in the table ?
| | How do you search the index ?
| |
| | I really hope someone can help me with this.
| |
| | --
| | Regards
| | Robert Vabo
| | Gecko AS
| | www.gecko.no
| |
| |
|
|
Received on Wed Aug 27 2003 - 23:58:02 CDT