Handling of the large datasets

Question

How the large datasets can be handled?

Answer 1

a) Using the Bulk utility mode during the session level and in case it is possible by disabling the constraints after consulting with the DBA.

b) Using the Bulk utility mode generally means that no writing is there in the Roll Back Segment so loading becomes faster. Though, the pitfall is that the recovery is generally not possible.