Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the SQL Loader and IMPORT
utilities?
- 3 Answers
- 20454 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 system database and what is a user database? : sql server DBA
how can a session indicate its interest in receiving alerts?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what do you understand by flashback feature of oracle?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is dbcc? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Where would you look for errors from the database engine?
what is a user-defined lock?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are statistics, under what circumstances they go out of date, how do you update them?
what is logical system in sap basis
