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 CREATE DATABASE syntax?

2 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

Why would you call update statistics? : sql server DBA

0 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---