It's all about the answers!

Ask a question

Where does RTC keep index table for work Items?

ryosuke oka (17984648) | asked Oct 22 '13, 12:55 a.m.
edited Oct 26 '13, 7:25 p.m. by Geoffrey Clemm (30.1k33035)
One of our client is looking for detailed information of Oracle tables for RTC database.
They would like to know where (table space) RTC create index table.

I thought index table on CCM table space but I can not see index table on it.
Is it on JTS table space?

What table actually have work Item data?
Setting up an Oracle database

If anyone know these, let me know.

Accepted answer

permanent link
Aradhya K (1.4k44345) | answered Oct 22 '13, 5:32 a.m.
 For Q1
There are 2 indexes with respect to the work items, the first one is the index for the full text search. This is stored in the file system of the App server. The path to this is there as part of the The other index is database index. these are the indices to the work item table itself.

For Q2
On Oracle the table names starting with Model_ are the work item tables.
ryosuke oka selected this answer as the correct answer

ryosuke oka commented Oct 24 '13, 2:35 a.m.

Thank you, Aradhay.
Your information will be very helpful !

ryosuke oka commented Oct 24 '13, 2:47 a.m.

one more question.
Do you know which table keep attachments of work Items?

Thank you.

ryosuke oka commented Oct 24 '13, 2:55 a.m.

Is it Attachment table for MODEL schema?

Aradhya K commented Oct 24 '13, 4:07 a.m.

MODEL_ATTACHMENT is the table name for attachment table,

I would not recommend you firing queries on any of the tables before talking to the development. 

Your answer

Register or to post your answer.