Gurus -

Due to time constraints and contract deadlines, we migrated/upgraded the
production database before the development database - not optimal, but
was required. We migrated/upgraded from existing hardware running
Oracle 9.2.0.8.0 on Linux AS 3 to new hardware running Oracle 10.2.0.3.0
on Linux AS 4. We had very few issues as I exported the data from
Oracle 9.2.0.8.0 and imported into the new 10.2.0.3.0 database, but I do
remember I had to rebuild all of the CONTEXT indexes because I did not
migrate the CTXSYS user account.

We finally found time and hardware to migrate/upgrade our development
environment and I followed the same procedures. Exported the old 9i
database and imported into a freshly built Oracle 10.2.0.3.0 database.
However, this time one of our CONTEXT indexes is not being built
properly. The "CREATE INDEX........IDEXTYPE IS ctxsys.context" runs
successfully, but when trying to query the data I am unable to return
any records. I have looked into the DR$indexname$I table to see what
data has been indexed and this table is empty. We have 7 CONTEXT
indexes in this database and this is the only one having problems.
However, this is the only index built on a LONG RAW datatype (remember -
we have no issue in our production environment with this index). Could
this be a LINUX issue with associating the filetypes (PDF, DOC, XLS)
stored in the database? Any ideas or suggestions would be greatly
appreciated.

Thanks
Bill



Oracle LazyDBA home page