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 are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1 Answers  


what do you understand by flashback feature of oracle?

1 Answers   Oracle,


How would you determine the time zone under which a database was operating?

2 Answers  


why Datapump is faster than traditional export and import

4 Answers   Mphasis,


What command would you use to encrypt a PL/SQL application?

1 Answers  


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1 Answers  


What are the different types of database compression introduced in sql server 2008? : sql server DBA

1 Answers  


You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

1 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


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

1 Answers  


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1 Answers  


Categories