Answer / kalyan maddipati

you mean to say that the same Oracle database should be at another place and what all the changes made to the Parent database should reflect on the child database? If U wanna that then it is know as parallel servers till 9.0 but from 10G we have the same concept with another name data guard.

Answer / pavana kumar.s

If the server is a linux box means,
Without Sychronization:
1.Just tar the oracle_base path and untar it on another server. This copies the databse including the oracle software.
2.Otherwise do the rman cloning.

With Synchronization:
Try to configure the Dataguard.

Answer / rajasekar

we cant replace an existing oracle server to any other
servers becoz oracle has its own rits to develop itself
couldn't convert it

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

what is a user-defined lock?

0 Answers   Oracle,

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

How can you rebuild an index?

6 Answers  

---