Anuj Singh Oracle DBA
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:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment