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

What is dbcc? : sql server DBA

0 Answers

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

Give two examples of how you might determine the structure of the table DEPT.

2 Answers

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers

How do you tell what your machine name is and what is its IP address?

4 Answers

Name two files used for network connection to a database.

5 Answers

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

What types of replication are supported in sql server? : sql server DBA

0 Answers

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here