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

What is proxy method?

976

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2097

---

What are the oracle built-in data types?

1080

---

What is a cursor variable?

1137

---

How to get the Installed Oracle Version Information ?

1128

---

What is enter substitution variable in oracle?

1057

---

What is the sql query to concatenate column values from multiple rows in oracle?

1063

---

please explain.. DB architecture ...

2029

---

How do I uninstall oracle 11g?

1123

---

Why do we use coalesce function in oracle?

1127

---

How to convert raw data type into text in oracle? Explain

995

---

How to bring a tablespace offline?

1067

---

Why does oracle 9i treat an empty string as null?

1063

---

What is instant client oracle?

1027

---

How to change system global area (sga) in oracle?

1013

---