Re: Indexing with interMedia

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:53:57 CDT