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 copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

---

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

1 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

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?

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---