No luck :-(

Stephen Price wrote:
> Did you try:
>
> exec CTX_DDL.SYNC_INDEX('SCHEMA.INDEX');
>
>
>
> Stephen Price
> Oracle Database Administrator
> Compusearch Software Systems, Inc.
>
>
> -----Original Message-----
> From: Bill Zakrzewski
> [mailto:oracledba-ezmlmshield-x64783342.[Email address protected]
> Sent: Thursday, January 31, 2008 2:24 PM
> To: LazyDBA Discussion
> Subject: CONTEXT index issue
>
> 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
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


Oracle LazyDBA home page