<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF76'>
/****************************************************************************/
/* GF76 ( ﾌｧｲﾙ検索ﾃｰﾌﾞﾙ )                                                  */
/* Created : 2015/05/26 19:23:15                                            */
/****************************************************************************/

<EXEC_SQL>
{call CTX_DDL.DROP_PREFERENCE('GF76_TXT')}
</EXEC_SQL>

<EXEC_SQL>
BEGIN
	CTX_DDL.CREATE_PREFERENCE('GF76_TXT','FILE_DATASTORE');
END;
</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF76_TXT_IDX
</EXEC_SQL>

<EXEC_SQL>
CREATE INDEX GF76_TXT_IDX ON GF76(FILEPATH)
	INDEXTYPE IS CTXSYS.CONTEXT
	PARAMETERS ('DATASTORE GF76_TXT FILTER CTXSYS.NULL_FILTER LEXER JPN_LX')
</EXEC_SQL>

<EXEC_SQL>
{call CTX_DDL.OPTIMIZE_INDEX( 'GF76_TXT_IDX','FULL' )}
</EXEC_SQL>
</ROWSET>
