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
What is a correlated sub-query? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What the different components in replication and what is their use? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What authentication modes does sql server support? : sql server DBA
What are the commands used in dcl? : sql server DBA
how to restore files with rman?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what are the differences of where and if in SAS?
What are the steps you will take to improve performance of a poor performing query?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you create a user-defined lock?
who owns the operating system files created by the utl_file package?
What are the different ways you can create databases in sql server? : sql server DBA
what are the types of connection load-balancing?