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

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

what are pseudocolumns?

4 Answers  

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

0 Answers  

---

Explain oracle instance.

0 Answers  

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers  

---

Difference between sub query and nested query ?

19 Answers   Keane India Ltd, TCS,

---

What is Rollback Segment ?

3 Answers  

---

How to handle a single quote in oracle sql?

0 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

what is analyze command ? what kind of statistics does it generate?

2 Answers  

---

How to write text literals in oracle?

0 Answers  

---

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  

---