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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What would you do with an "in-doubt" distributed transaction?

1411


What is dbcc? : sql server DBA

771


What authentication modes does sql server support? : sql server DBA

688


when does an alert gets signaled?

572


what is asm?

593






what do you understand by fine-grained auditing?

619


what are the types of connection load-balancing?

555


what is a crs resource?

586


how can you schedule a job in database?

589


how can you find out if a table can be redefined?

591


How can you control the amount of free space in your index pages? : sql server DBA

719


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1857


what functionality does oracle provide to secure sensitive information?

543


Why would you use sql agent? : sql server DBA

567


what is logical system in sap basis

1124