<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF83'>
/****************************************************************************/
/* GF83 ( DBｵﾌﾞｼﾞｪｸﾄ明細 )                                                  */
/* Created : 2015/05/26 19:23:15                                            */
/****************************************************************************/

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

<EXEC_SQL>
BEGIN
	CTX_DDL.CREATE_PREFERENCE('GF83_TXT', 'DIRECT_DATASTORE');
END;
</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF83_TXT_IDX
</EXEC_SQL>

<EXEC_SQL>
CREATE INDEX GF83_TXT_IDX ON GF83(SRC_TEXT)
	INDEXTYPE IS CTXSYS.CONTEXT
	PARAMETERS ('DATASTORE GF83_TXT LEXER JPN_LX')
</EXEC_SQL>

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