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
what functionality does oracle provide to secure sensitive information?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is a correlated sub-query? : sql server DBA
What is dcl? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What happens on checkpoint? : sql server DBA
what are the types of connection load-balancing?
What are the different types of upgrades that can be performed 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.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What the different components in replication and what is their use? : sql server DBA