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

How to define an oracle cursor variable?

0 Answers  

---

How to create id with auto_increment on oracle?

0 Answers  

---

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

---

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

2 Answers  

---

find out the second highest salary?

55 Answers   Cognizant, Nucsoft, Oracle, TCS, Wondersoft,

---

How would you optimize a slow SQL query?

1 Answers  

---

Display the number value in Words?

1 Answers  

---

What is a proxy object?

0 Answers  

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

What is a partition in oracle?

0 Answers  

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

0 Answers   Wipro,

---

How to retrieve data from an cursor to a record?

0 Answers  

---