Answer Posted / ravindra

Hi,

Correct if i am wrong.We can do through package
procedure.Create empty database on target database and
create dblink between two databases.Now we have to prepare
package and transfer the each schema.
Thanks & Regards,
Ravindra

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2572

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1356

---

What is the default port no on which sql server listens? : sql server DBA

1210

---

when does an alert gets signaled?

1105

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4476

---

what are the performance views in an oracle rac environment?

1117

---

how can you connect from 10g user to 11g user??

2161

---

how can you create a user-defined lock?

1053

---

Explain materialized views and how they are used.

2496

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1088

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1133

---

What is dcl? : sql server DBA

1313

---

what is grd?

1152

---

what functionality does oracle provide to secure sensitive information?

1048

---

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?

3448

---