Oracle, Legacy Export,Direct Vs Conventional path working
I have a few confusions and are mentioned below regarding legacy export in oracle.
Please find the meta link artical ID 76329.1, in which a diagram had given. I have below doubt from this as well my own doubts.
1) How does a table is exported from database?
2) What are the layers (like...OS filesystem memory,oracle SGA and so on) touches in this export
3) In this artical [ID 76329.1], I am not clear about the terminalogies. Please can some one explain me.
a) row-Major order conversion
b) column-major order conversion
c) data layer
d) export output buffer
In the diagram I am not sure whether they are mentioing the SGA's buffer cache or OS filesystem buffer cache.