I have heard that using direct=y in an export the import would be much faster, my question is there any situation where we cannot use direct=y? If direct is recommendable why by default is N? Can we always use direct=y?
Also can anyone clarify the meaning of buffer and arraysize in import, how are they measured, in number of rows, bytes or blocks?