Compare to snapshot?

[Allan Streib]

We are in an environment where it is not possible to be simultaneously connected to the test database and the production database. Is it possible to run a schema object compare against an offline snapshot of the target schema?

 

[ScottMattes]

You could log onto the Production instance and run a query that returns all the info and save the results to a file. Then connect to the test instance and do the same. Then use the ExamDiff tool provided with PL/SQL Dev.