<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF23'>
/****************************************************************************/
/* GF23 ( JAVADOCｸﾗｽ定義ﾌｧｲﾙ )                                              */
/* Created : 2015/05/26 19:23:15                                            */
/****************************************************************************/

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

<EXEC_SQL>
BEGIN
	CTX_DDL.CREATE_PREFERENCE('GF23_TXT', 'MULTI_COLUMN_DATASTORE');
	CTX_DDL.SET_ATTRIBUTE('GF23_TXT', 'COLUMNS', 'DESCRIPTION, CONTENTS, FORM_SAMPLE');
END;
</EXEC_SQL>

<EXEC_SQL>
DROP INDEX GF23_TXT_IDX
</EXEC_SQL>

<EXEC_SQL>
CREATE INDEX GF23_TXT_IDX ON GF23 (FGJ)
	INDEXTYPE IS CTXSYS.CONTEXT
	PARAMETERS ('DATASTORE GF23_TXT LEXER JPN_LX')
</EXEC_SQL>

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