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
20464 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

Datapump backup steps?

1 Answers

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

what is a crs resource?

0 Answers Oracle,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

What authentication modes does sql server support? : sql server DBA

0 Answers

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

how can you connect from 10g user to 11g user??

0 Answers HP,

What is the difference between online backup & offline backup?

3 Answers CSC,

What is the importance of a recovery model? : sql server DBA

0 Answers

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers

For more DB Administration Interview Questions Click Here