2 Replies Latest reply: Oct 14, 2010 5:22 AM by 735506 RSS

    Separate tables with current and historical data

    735506
      Hello,

      does anyone maybe know if Oracle Workspace Manager has some functionality to separate current data and historical data?

      From the versioning enabled table 2 tables should arise. First one with current data and other with historical data and vertical decomposition supported...

      It is important from the redundancy point of view. If no such mechanism, complex triggers or perhaps ETL should be implemented ourselve.

      Regards