Export / Import of Oracle Text Indices

From: Russell Lear <russelllear_at_earthlink.net>
Date: Thu, 05 Feb 2004 04:07:36 GMT
Message-ID: <ckjUb.13793$uM2.8915@newsread1.news.pas.earthlink.net>

I have some tables, each of which have columns pointing to PDF files. I use Oracle Text to index the content of those PDF files for fast content searches. Everything has been going along quite nicely, but now I need to export the data for a user-selected table, drop that table and, some time later, re-import the table. I need the content indexes to be preserved and I need the import to be fast.

I have been exporting the table data, preserving triggers. Later, when I import the table, Oracle automatically re-creates the indexing information by scanning the referenced files. It is this re-scanning that is kind of a problem since it can take a relatively long time.

What I would like to do is to export my data and the contents of the four indexing tables and re-import them all as a whole. I can ensure that nothing changes - I just want to preserve the state of the tables and indices and re-create that state later. Unfortunately, Oracle has taken some care to make sure I can't export the data in the indexing tables. (export complains that the tables don't exist). I understand why they do that, but I'd sure like a work-around or some way to speed up the re-loading.

Any thoughts? Or am I dreaming?

Thanks,
Russell. Received on Wed Feb 04 2004 - 22:07:36 CST