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

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 type of index should you use on a fact table?

1 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  


What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


What the different types of replication and why are they used? : sql server DBA

0 Answers  


How can we know the exact updation date of a particular database?

2 Answers   Satyam,






when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 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  


Name two files used for network connection to a database.

5 Answers  


what is the difference between db2start command and start database manager command?

1 Answers  


Which autogrowth database setting is good? : sql server DBA

0 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


Give two examples of referential integrity constraints.

2 Answers  


Categories