Home / Oracle DBA / about ORACLE UTILITIES ( SQL * Loader )

about ORACLE UTILITIES ( SQL * Loader )

ORACLE UTILITIES

SQL * LOADER
  1. It is a utility to load the data from a textfile to oracle table
  2. The textfile is called as flat file. It can be in .txt, .csv, etc format
  3. SQL *LOADER contains following components
    1. CONTROL FILE – this will define the configuration parameters which tell how to load the data into the table. It has nothing to do with database control file
    2. INPUT FILE or INFILE – this is the file from which data should be loaded
    3. BADFILE – records which are failed to load into table (due to any reason) will be stored in this file
    4. DISCARDFILE – records which doesn’t satisfy the condition will be placed here
    5. LOGFILE – it will record the action of sql * loader and can be used for reference
  4. SQL * LOADER can be invoked as follows
    [oracle@server1 admin]$ sqlldruserid=system/oracle control=control.lst log=track.log

ORACLE UTILITIES

Read More:
ORACLE PASSWORD FILE (PFILE)
Creating new Listener manually
TYPES OF ERRORS in Oracle database
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe