What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 19553 Views
- I also Faced
- E-Mail Answers
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
how can you enable flashback feature?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Can you redefine a table online?
how can you get actual data change values from previous transactions in oracle?
Which autogrowth database setting is good? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what are the differences of where and if in SAS?
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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is the use of ocr?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is dbcc? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
