What is the difference between the SQL Loader and IMPORT
utilities?
Answers were Sorted based on User's Feedback
Answer / kunal sain
Sql loader can import data from any flat files
where as import command import data from exported file.
| Is This Answer Correct ? | 23 Yes | 1 No |
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 |
Answer / 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 |
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what do you understand by flashback feature of oracle?
How would you determine the time zone under which a database was operating?
why Datapump is faster than traditional export and import
What command would you use to encrypt a PL/SQL application?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is the difference between db2start command and start database manager command?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)