What is SQL*Loader?
- SQL Loader is a tool used to upload data from flat files to oracle database.
- Data can be uploaded from various flat files to different databases in the same session.
- It is also used to upload LOBs like images, text and xml files into lob columns.
- The control file is used to configure the SQL loader as per given parameters.
- Performance also should be considered while using the tool.
- Use of direct path load is preferred over conventional path load for better performance.
- Oracle functions like TO_DATE and TO_NUMBER also can be used to format the data while insertion.
Oracle SQL*Loader: The Definitive Guide
Posts
No comments:
Post a Comment