Hello Team,

I would like to know is there any provision for parallelly copying data from main table (one schema) to different schema table without hampering current traffic?

We need such provision/approach which should be faster way of doing this.

Please suggest or guide us how we can do this?

Please note: we want to create new schema which contains same table like in main schema. As soon as SQL operation happens on main schema table same should get copied to different new schema as well in faster way. We need to use this new schema for only reporting purpose so we need to develop this approach.


please guide us on this as soon as possible.

Thanks & Regards,
Shital

insert /*+ enable_parallel_dml append */ into target
select /*+ parallel */ ... from source;