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

How many categories of data types in oracle?

970

---

How to get maxsal , minsal, ename department wise in single query

1506

---

What is the difference between sharding and replication?

971

---

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

1062

---

How to create a table in a specific tablespace?

923

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2080

---

how can we store any pdf file in oracle

2105

---

what is the difference between data migration and production migration.

2282

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1028

---

What is the difference between count (*), count (expression), count (distinct expression)?

968

---

Give the constructs of a package, function or a procedure.

990

---

Can multiple columns be used in group by in oracle?

937

---

What are the original export and import utilities?

1070

---

How to bring a tablespace offline?

1006

---

What happens to the current transaction if the session is ended?

1045

---