Summary

In this chapter, the techniques of data migration were discussed. Third-party applications or non-Oracle databases can provide input files in various formats by getting the mapping instructions from the data layer to the database. Data loading can be operated by the SQL Loader consisting of the data (UNL) and control (CTL) files. The process is straightforward, and data rows that cannot be loaded can be easily identified. Raised exception details are present for each refused row.

The client side or the server side can manage data and shift it across Oracle platforms. In this chapter, we dealt with the principles and limitations of this approach by emphasizing the differences between client-side and server-side import and export operations. The main focus was on the Oracle Cloud as a destination by dealing with Object Storage and buckets. The server-side import and export types use the Oracle directory object to access the data storage layer. To make the files available through...