Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design database draw er diagram for a certain scenario ?
How to put more than 1000 values into an oracle in clause?
How to start an oracle instance?
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
What is oracle latest version?
How to use values from other tables in update statements using oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
