Search This Blog

Total Pageviews

Friday, 25 February 2011

Oracle text index re create script

spool index_scripts.lst
set long 2000000000
set head off
set pagesize 10000

select ctx_report.create_index_script ('username.text_index_name') from dual;

select ctx_report.describe_index('username.text_index_name') FROM DUAL;

spool off

No comments:

Oracle DBA

anuj blog Archive