Question on Parallel operation
I have doubt on below question. Please explain:
1. Can multiple partitions of a table be exchanged in parallel? If not will they serialize or give ORA error?
2. Can a DML run on a partition of a table in parallel when another partition is being exchanged? If not will it serialize or give ORA error?
3. Can a DML run on a partition of a table in parallel when the same partition is being exchanged? If not will it serialize or give ORA error?
4. Can a query run on a partition of a table in parallel when another partition is being exchanged? If not will it serialize or give ORA error?