This content has been marked as final. Show 2 replies
You can use ctx_report to get all the information about an index.
I use it from SQL*Plus like this:
The only thing this won't give you is the source for any procedures used in the user_datastore. You can get that from user_sources.
set pagesize 0 set heading off set trimspool on set long 500000 spool index.sql select ctx_report.create_index_script('MyIndexName') from dual; spool off
Beautiful query ! Thank you :)