| Modified objects [message #567501] |
Tue, 02 October 2012 14:49  |
|
|
I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.
a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.
|
|
|
|
|
|
| Re: Modified objects [message #567509 is a reply to message #567501] |
Wed, 03 October 2012 00:20  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If you have Enterprise Edition licences (and, by the way, I very much doubt that you are using release 10.0.1.0) then Streams will synchnronize the objects automatically, DML, DDL, or both.
--
edit: typo
[Updated on: Wed, 03 October 2012 01:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
