Answer / 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).

Is oracle a relational database?

0 Answers  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

What are the differences between lov and list item?

0 Answers  

---

Why do we need oracle client?

0 Answers  

---

What is save point in oracle database?

0 Answers  

---

What happens if you set the sga too low in oracle?

0 Answers  

---

What are the commands youd issue to show the explain plan for select

2 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

What is difference between truncate and delete?

0 Answers  

---

What are the types of partitions in oracle?

0 Answers  

---