O'Reilly logo

Oracle 10g/11g Data and Database Management Utilities by Hector R. Madrid

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. SQL*Loader

Transferring data in plain text file format is common when performing tasks such as loading a database for the first time, data warehouse maintenance, ASCII backups, or spatial data management. Knowing how to efficiently use and tailor this tool allows the user to optimize the time invested in performing one of the most labor intensive and time consuming maintenance tasks.

During the upload process it is important to foresee any space allocation issues that may prevent the load process from successfully finishing. It is important to either gauge the tablespace requirements, or proactively launch automatic space management tasks.

It is important to know how to perform the data load with different character sets, so that users ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required