2
Data Loading and Migration Perspectives
The data loading process is essential for feeding databases with external data sources. It can be used to load new objects or to update existing objects and their content in the database. Appropriate knowledge is required; otherwise, everything would need to be done on the fly without any robust support, which would raise many problems. Data loading is a complex process of copying and loading data while maintaining data integrity. Commonly, huge datasets need to be loaded, whether from the Oracle database, a different database system, or any system generally.
Three solutions are discussed in this chapter – SQL Loader, client-side import, and server-side import using dump files. Finally, Oracle Cloud ...
Get Developing Robust Date and Time Oriented Applications in Oracle Cloud now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
