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
19541 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 can you record information about current session?

0 Answers Oracle,

How can you gather statistics on a table?

3 Answers

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

0 Answers

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

0 Answers

what is rebuild index??

2 Answers IBM, Sapient,

what is the difference between hot backup n rman backup?

1 Answers Value Labs,

what is the use of ocr?

0 Answers Oracle,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

how can you schedule a job in database?

0 Answers Oracle,

What is a correlated sub-query? : sql server DBA

0 Answers

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

For more DB Administration Interview Questions Click Here