All geek questions in one place

How to cache XMLTYPE table in TimesTen database?

I have an XMLType table in the oracle database that I want to cache in the timesten ket group. But since the restriction that the definition of the table in the cache group must be the same as in the Oracle database, and the fact that the timesten database does not yet support xml data, I could not cache my table as it is. So I demand, if anyone has an idea, how can I cache xml data in a timesten database?

Also I cannot change the definition of the table. I know that caching XML data as CLOBs in a cache group is possible, but I do not want to change the definition of my table.

thanks

+4
source share
1 answer

There is no CLOB no XMLType, but if that is enough for you: TimesTen VARCHAR2 can contain up to 4,194,304 bytes.

http://docs.oracle.com/cd/E13085_01/doc/timesten.1121/e13076/dtypesfunc.htm#BCGFBBJI

0
source

Source: https://habr.com/ru/post/1345231/

More articles:


All Articles