What is the difference between the sq loader and import and export utility

One is the sqll loader can be used in data files not dmp files.

import and exprort utility fopr dmp files

Hi Friend,


SQL Loader is used to Load the Data from Delimiter Seperted
files and files with fixed and Vaariable width Text
One can also use plsql functions and procedures to load
desired foramtted data.


Import is the Utility that can only tool that understands
Oracle Export Utility used to manke logical backup against Database/Schemas.


Sql loader can import data from any flat files
where as import command import data from exported file.


Thanks.....

sql loader is used to load data into database tables from flat files.

exp/expdp is used to create a dump file (backup) for the database. expdp is used in version 10 onwards.

imp/impdp is used to recreate the database from a dump file (backup) for the database. impdp is used in version 10 onwards.