5 Replies Latest reply: Mar 14, 2012 10:06 PM by Rajeshp-Oracle RSS

    Does TT could use partition?

    915434
      Hi all,

      Now I met a problem, My data in Oracle DB has stored more and more. So I want use partition in Oracle. However, Does TT support partition? if yes, How?
        • 1. Re: Does TT could use partition?
          Rajeshp-Oracle
          TT doesn't have Oracle like partitions concept for normal tables , but we allow creating cache groups on tables which is partitioned in oracle.


          Caching Oracle partitioned tables
          =====================

          You can define Oracle partitioned tables in a cache group by following the same
          conventions as you would when caching regular Oracle tables. For example, a
          partitioned table in a read-only cache group must have a corresponding unique,
          non-null index in Oracle. The partitioned table used in the cache group can be
          partitioned or subpartitioned in any manner (hash, list, range or composite).

          Edited by: rajeshp on Mar 12, 2012 3:20 AM
          • 2. Re: Does TT could use partition?
            915434
            Well, Thanks rajeshp.

            You mean once I create a partition table in oracle which use a number value to partition, I should create several table in TT cachegroups?

            However, how to create a partition table automaticlly in TT, use an job and scripts?

            Raul.
            • 3. Re: Does TT could use partition?
              Rajeshp-Oracle
              Let me clarify a little. We can't create Partition table in Timesten as such for normal tables.

              But We have IMDB cache where you cache Oracle tables to Timesten. When you create a cache group, the oracle table will be created in Timesten.

              You can find more abut IMDB cache here

              http://docs.oracle.com/cd/E13085_01/doc/timesten.1121/e13073/concepts.htm#BABFBIEC

              For Partitioned Oracle tables, you can cache the table in Timesten like normal tables.
              • 4. Re: Does TT could use partition?
                915434
                Hi rajeshp,

                I found a way to slove the problem. I had create a partition table A which partition condition is date in oracle, then I created a temp table B like A, and a tt table C like B. Once insert a value into C, the data synchronous upload to B, At the trriger bettween A and B become active. the data was stored in A finally.
                Am I right?
                raul.
                • 5. Re: Does TT could use partition?
                  Rajeshp-Oracle
                  Can you tell us about this ..." the data synchronous upload to B" ?

                  Are you using SWT cachegroup here ? Or using "passthrough" to write data from TT to Oracle ?