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
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what do you understand by fine-grained auditing?
How would you best determine why your MVIEW couldn't FAST REFRESH?
What the different topologies in which replication can be configured? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
what is logical system in sap basis
What are the commands you'd issue to show the explain plan for "select * from dual"?
what do you understand by flashback feature of oracle?
when does an alert gets signaled?
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
what is the use of ocr?
what is the role of dip user in our database?
Why does Oracle not permit the use of PCTUSED with indexes?
What the different components in replication and what is their use? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.