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.

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

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  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

Explain an ORA-01555

2 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 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?

0 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---