Reviewal / Approval logic can easily be added to a streams configuration. Streams consist of a capture, propagation and apply process, each of which can be activated and controlled the way you need it. I.e. you could capture and propagate constantly to an intermediate site, and have the apply process stopped until you're done reviewing your data, and fire it off manually to apply the changes.
We are looking for a tool to migrate delta changes in table rows in a controlled way. Meaning we should be able to review and approve row changes and migrate to test and production. I know there are data replication tools such as Streams, Data Guard, SharePlex etc. but those tools replicate at redo log level or do not have review/approval logic. Any input in this regard is highly appreciated.