Answer / Vipnesh Sharma

To synchronize two schema's objects, you can use database tools like Oracle Data Modeler or SQL Developer. Here is a general approach:
1. Create a comparison script using the 'compare' command in SQL Developer. This will generate a script that identifies differences between the objects of the two schemas.
2. Review and analyze the output from the comparison script, and decide which changes you want to apply.
3. Apply the necessary changes using SQL scripts. For example, if there are differences in table structures, you can create or modify tables as needed. If there are differences in data, you can use 'insert', 'update', and 'delete' statements to synchronize the data.

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

How to create an oracle testing table?

1 Answers  

---

How to handle a single quote in oracle sql?

1 Answers  

---

How to get a list of all user accounts in the database?

1 Answers  

---

how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

Explain the use of tables option in exp command.

1 Answers  

---

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1 Answers  

---

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

9 Answers   BPO, Excel, Wipro,

---

What are Clusters ?

5 Answers   Amdocs, Infosys,

---

What is the use of file param in imp command?

1 Answers  

---

How to start instance with a minimal initialization parameter file?

1 Answers  

---