2 Replies Latest reply on Oct 14, 2010 10:22 AM by 735506

    Separate tables with current and historical data


      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.