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

Does facebook use oracle?

1017

---

what are the advantages of running a database in archive log mode?

2182

---

How to connect ms access to oracle servers?

979

---

What is varray?

1108

---

How to get a list of all background sessions in the database?

970

---

What is program global area (pga) in oracle?

1011

---

What is the maximum limit on the number of columns in a table?

1068

---

What is raw datatype?

1112

---

What are the advantages of oracle 12c?

1157

---

Is rowid unique in oracle?

978

---

What is Reduced List of Values?

2147

---

What is the exact use of Collections?

2130

---

How to pass a parameter to a cursor in oracle?

1154

---

How to experiment a data lock in oracle?

1039

---

Why do we use bulk collect in oracle?

1043

---