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 do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

Oracle 11g new features?

2 Answers  

---