Script oracle for compare two schema ddl and dml

Some third party tools could be used.

http://www.dkgas.com/oradbdiff.htm
http://www.impacttoys.com/
http://www.softtreetech.com/dbtools/

Check TOAD -> compare schemas option.

Hi,

Thanks, I can't use tool.
I search to have an idea for scripting schema diff.

Regards

Brigitte

Use DBMS_METADATA to extract the ddls...
check this out...
http://pandazen.wordpress.com/2008/02/09/using-the-dbms_metadata-package-to-extract-all-the-schema-ddl-with-one-call/ 

Hi,

Thanks but how generate the diff script for upgrade the other schema like Toad.

Regards

Bibi

Ok.
how do you do it in TOAD?
Just curious.

Hi,

With toad, it is possible to use the tool database-Compare schema but I search a script with the same functionnality, toad isn't free.

Thanks

Regards

I understand the TOAD compare schema. How do you sync the difference?
another idea for comparing the schema....
https://www.experts-exchange.com/questions/23857108/how-to-write-batch-file-to-compare-two-schemas.html 

The sync script is generate automatically with toad

Hi,

I search always a solution to compare dml between two schemas.

Thanks

Regards

Bibi92