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 to assign values to variables?

1067

---

How do you bind variables in oracle?

947

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4313

---

how do u setup a replication site?

1950

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2169

---

Is oracle an open source?

1038

---

is there a tool to trace queries, like profiler for sql server?

1104

---

How to create a server parameter file?

1099

---

What are the restrictions in a oracle read only transaction?

990

---

What are the set operators union, union all, minus & intersect meant to do?

961

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2260

---

How to specify default values in insert statement using oracle?

1068

---

What are triggers in oracle?

990

---

What is the relation of a user account and a schema?

1082

---

Why should I use oracle database?

966

---