Answer / s. senthil kumar

exp username/password@databasename file=c:\filename.DMP
full=N log=c:\filename.LOG

Answer / divyadeepa

>exp ddk/log@orcl file={file location path}

Answer / ace dba

A dump is _NOT_ a backup. You cannot roll forward to a
point in time after the dump was taken. The dump is for
moving data from one environment to another, and etc. Using
dump for backup _WILL_ result in data loss.

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

How to drop a tablespace?

0 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

0 Answers  

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

What is an UTL_FILE.What are different procedures and functions associated with it?

1 Answers  

---

what are archived logs?

0 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

Explain mutating triggers.

0 Answers  

---

What is an oracle user account?

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

0 Answers   Zensar,

---

What are the restrictions on external table columns?

0 Answers  

---