What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 18871 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 correlated sub-query? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
which background process invoke at the time of upgradation tell me???
What are the commands used in dcl? : sql server DBA
what is asm?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the default fill factor value? : sql server DBA
how can a session indicate its interest in receiving alerts?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what do you understand by fine-grained auditing?
how can you process messages in order asynchronously?
how does an oracle clusterware manage crs resources?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
