Database Administrator (DBA) Question:

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

Tweet Share WhatsApp

Answer:

These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL*Loader utility allows data to be loaded that has been produced by other utilities from different data sources just so long as it conforms to ASCII formatted or delimited files.

Download Database Administrator (DBA) PDF Read All 253 Database Administrator (DBA) Questions
Previous QuestionNext Question
How can you enable a trace for a session?What is a database schema?