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.

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

internal architecture

0 Answers   CSC,

---

What is the dataguard background process??

1 Answers   iGate,

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

how to restore files with rman?

0 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---