Answer / kunal sain

Sql loader can import data from any flat files
where as import command import data from exported file.

Answer / 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

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.

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

How would you determine who has added a row to a table?

4 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---