SQL*Loader is indeed a great tool and by far the fastest way to load a csv/txt file inside your database. It has so many features that can be sometimes confusing.
The syntax of the control file is complex and, as I said in the external table topic, be prepared to copy some sample from the official documentation, adapt and reuse in your exam if needed. If you try to create one from scratch, be prepared to stay your whole exam in one single exercise.
So, for this topic, be prepared to load a file into a table with also those datatypes:
- Object Types
- LOBs
Path to Documentation:
Utilities -> Part II SQL*Loader
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
