What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 19596 Views
- I also Faced
- E-Mail Answers
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
internal architecture
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What are the recovery models for a database? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what is a user-defined lock?
how can you initialize log miner?
what is grd?
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 do you trace the traffic hitting a sql server? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is ora 24313?what is the procedure to exclude that error?
which background process invoke at the time of upgradation tell me???
What are the different ways you can create databases in sql server? : sql server DBA
