Answer Posted / pugal

The following examples demonstrate how imp/exp can be used:

exp scott/tiger file=emp.dmp log=emp.log
tables=emp rows=yes indexes=no

exp scott/tiger file=emp.dmp tables=(emp,dept)

imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott
touser=scott tables=dept

exp userid=scott/tiger@orcl parfile=export.txt

... where export.txt contains:
BUFFER=100000
FILE=account.dmp
FULL=n
OWNER=scott
GRANTS=y
COMPRESS=y

NOTE: If you do not like command line utilities, you can
import and export data with the "Schema Manager" GUI that
ships with Oracle Enterprise Manager (OEM).

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1326

---

What is a snapshot log?

952

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1852

---

Explain a segment?

1020

---

What is the difference between translate and replace in oracle?

1115

---

What is partitioned table in Oracle?

1107

---

Can objects of the same schema reside in different tablespace?

1002

---

What is format trigger?

2016

---

How to drop an existing table in oracle?

1015

---

Difference between oracle's plus (+) notation and ansi join notation?

1034

---

Why do you create or replace procedures rather that drop and recreate.

948

---

what is the use of system.effective.date variable in oracle?

1056

---

How to use "in out" parameter properly?

1000

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2291

---

Explain oracle left join with an example?

956

---