January 15th, 2004, 09:01 AM
Creating full text index
I have a table called Documents that stores PDF files in a blob column. The table has approximately 50,000 rows. I have attempted to create a full text index on the table, but after letting the create index process run for over 40 hours, the index creation was not finished. Since this is a production database, I had to kill the process in order to allow users access to the table.
Since I am a developer and not an Oracle DBA, I could use any and all advice/suggestions.
Using ORACLE 8i and attempted to create the index using the interMedia Text Manager.
January 15th, 2004, 09:44 AM
Have you attempted to create this in a development environment? If so, what where the results?
January 15th, 2004, 09:45 AM
Did test in a development environment. However, the data sample was small (only about 100 rows) and the index was created in a reasonable amount of time.
January 15th, 2004, 09:57 AM
Can you create a duplicate copy of the table and build the index offline?
January 15th, 2004, 10:22 AM
Not sure how to accomplish what you suggest.
January 15th, 2004, 04:56 PM
Create a backup of the table create the index apply the changes that have occurred since the table has been offline. Replace the existing table with the new table.