FND_LOBS_CTX rebuiding

SQL> drop index APPLSYS.FND_LOBS_CTX;


SQL> select
FILE_FORMAT,
count(*)
from
fnd_lobs
group by FILE_FORMAT;  2    3    4    5    6

FILE_FORMA   COUNT(*)
---------- ----------
binary           5736
text            39437
IGNORE            484

SQL> update fnd_lobs
set FILE_FORMAT = 'IGNORE'
where NVL(PROGRAM_NAME,'NULL') != 'FND_HELP' ;  2    3

484 rows updated.

SQL> commit;

Commit complete.

SQL> select status
from all_indexes
where owner='APPLSYS'
and index_name='FND_LOBS_CTX'
and table_name='FND_LOBS';  2    3    4    5

no rows selected

SQL> @$FND_TOP/sql/aflobbld.sql applsys apps

PL/SQL procedure successfully completed.


Commit complete.

SQL> update fnd_lobs
set file_format = fnd_gfm.set_file_format(file_content_type);  2

45657 rows updated.

SQL> commit;

Commit complete.

SQL> select
FILE_FORMAT,
count(*)
from
fnd_lobs
group by FILE_FORMAT;  2    3    4    5    6

FILE_FORMA   COUNT(*)
---------- ----------
IGNORE           5736
TEXT            39879
BINARY             42

SQL> select status
from all_indexes
where owner='APPLSYS'
and index_name='FND_LOBS_CTX'
and table_name='FND_LOBS';  2    3    4    5

STATUS
--------
VALID