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.
Both current and historical data are always stored within the same table. There is no option to create separate tables for each that are managed by OWM.
However, you do have the option to use dbms_wm.PurgeTable which can be used to purge a set of data, and optionally store it in a archive table. But, after that is done the data is no longer under Workspace manager's control or the versioning environment. From the description that you gave, I am unsure if this would be sufficient to satisfy your requirements. I am guessing not, but wanted to make you aware of the functionality.