What is the difference between the SQL Loader and IMPORT
utilities?
Answer Posted / 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 View All Answers
Where would you look for errors from the database engine?
what do you understand by flashback feature of oracle?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what are the performance views in an oracle rac environment?
What are statistics, under what circumstances they go out of date, how do you update them?
How can you control the amount of free space in your index pages? : sql server DBA
What is transparent data encryption? : sql server DBA
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
what is the role of dip user in our database?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Which autogrowth database setting is good? : sql server DBA
What is fill factor? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.