- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Oracle Text index information
I have an Oracle Text index that has been created as:
create index my_docs_doc_idx on my_docs(doc)
indextype is ctxsys.context;
So, the table is MY_DOCS, the indexed column is DOC.
But, when I query the views dba_tables I find tables with that names DR$MY_DOCS_DOC_IDX$K and DR$MY_DOCS_DOC_IDX$N.
that are (regarding the naming) related to the index MY_DOCS_DOC_IDX.
Furthetmore, when I query the table dba_indexes, I find for the above tables, indexes of the type SYS_IL, SYS_IOT.
Does someone know what means these tables and index names?
Does someone know I to get Oracle Text information: name, corresponding table, size, free space, allocated (used) space?
Thanks by advance for any tip, if you have some experience with it.