Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Text index information

LauryAug 20 2017 — edited Aug 31 2017

Hi,

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.

Kind Regards

This post has been answered by Roger Ford-Oracle on Aug 21 2017
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 18 2017
Added on Aug 20 2017
2 comments
1,239 views