RG 007 wrote:There is an option for DB log based CDC .
I need to move data within 11G same database from one schema to another schema but relational to dimensional model.
When I create CDC on source tables it tries to create triggers.
But I don't have create trigger permission, I have only select permission.
So, is there any other way to capture real time data without any super user permission.
Also, Instead of using source tables,if I create a view of source tables in target schema and use these views in interface, will it create any impact on performance.Performance is a relative term .You need to test it before coming to any conclution.
Thanks in advance.