Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 20441 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh
SQL Loader and IMPORT are ORACLE utilities
SQL Loader is used to Load the Data from Delimiter Seperted
files and files with fixed and Vaariable width Text
One can also use plsql functions and procedures to load
desired foramtted data
Import is the Utility that can only tool that understands
Oracle Export Utility used to manke logical backup against
Database/Schemas
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
what is a user-defined lock?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the importance of a recovery model? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
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 the use of recording information about current session?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What is fill factor? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
which background process invoke at the time of upgradation tell me???
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 transparent data encryption? : sql server DBA
