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

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

Question Posted / guest

3 Answers
20424 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / kunal sain

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

Is This Answer Correct ?

23 Yes

1 No

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

Answer / ramesh

SQL Loader and IMPORT are ORACLE utilities

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

Is This Answer Correct ?

10 Yes

2 No

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

Answer / chandrashekar

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.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More DB Administration Interview Questions

How to make a replica of existing oracle server to another server?

3 Answers

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

Which environment variables are absolutely critical in order to run the OUI?