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 is logical system in sap basis
how can you initialize log miner?
What are the different sql server versions you have worked on? : 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
What is dcl? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different ways you can create databases in sql server? : sql server DBA
What are the commands used in dcl? : sql server DBA
how does an oracle clusterware manage crs resources?
what is the use of recording information about current session?
how can you get actual data change values from previous transactions in oracle?
What the different topologies in which replication can be configured? : sql server DBA
what is grd?