How to generate difference DDL after comparing 2 schemas
Suppose I have schema A in database B and Schema C in database D
User is applying some changes in schema A while Schema C is unchanged.
At this time I need to gather DDL of only changed objects of schema A that could be change in columns,addition of tables,addition of sequence...etc
We know Toad and other GUI utilities can do but we have to do it from command line script
Can someone please help or know any such script