Answer / kittu_chintu2005

Create a file structure @ oracle level by issuing the statement "create directory dpump_dir1 as '/disk01/oradata/mine/dpump'';" "grant read, write to user1, user2;"
@ OS "level mkdir -p /disk01/oradata/mine/dpump"

And then issue the statement @ OS level "expdp directory=dpump_dir1 dumpfile=xxxxx.dmp"

Explain the use of table functions.

1 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---