Difference between the SQL*Loader and IMPORT utilities

What is the difference between the SQL*Loader and IMPORT utilities?

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads.

Oracle's export (exp) and import (imp) utilities are used to perform logical database backup and recovery. When exporting, database objects are dumped to a binary file which can then be imported into another Oracle database.
Difference between locks, latches, enqueues and semaphores
Difference between locks, latches, enqueues and semaphores - Latches are used to protect Oracles data structures to be modified or run by more than one process...
Oracle system privilege
Oracle system privilege - user privileges, developer privileges, “any” privileges, database maintenance, monitoring privileges.....
Explain sub-queries in brief
Sub-query is the technique that lets us use the result of one query as part of another query.....
Post your comment

Related Content

Follow us

▲