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 the use of recording information about current session?
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
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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?
Can you redefine a table online?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is the diffrence between core dba and apps dba?
how can you record information about current session?
what is the role of dip user in our database?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How to start SQL Server in minimal configuration mode?
what do you understand by flashback feature of oracle?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you use sql agent? : sql server DBA