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 |
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How does Oracle guarantee data integrity of data changes?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How would you determine what sessions are connected and what resources they are waiting for?
any body know about orawaves do they really provide placements in their unique placement program
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
What are the different ways of moving data or databases between servers and databases in SQL Server?
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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How to start SQL Server in minimal configuration mode?
Oracle (3259)
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)