What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 19170 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 are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
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
how can you schedule a job in database?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Why would you call update statistics? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what are the differences of where and if in SAS?
what are the benefits of flashback feature?
what are the performance views in an oracle rac environment?
What is a correlated sub-query? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what do you understand by fine-grained auditing?
What are the steps you will take to improve performance of a poor performing query?
What is the difference between clustered and non-clustered index? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
