To find all differences between schemas I have to run 'Compare User Objects' twice ie. after the first compare is complete I have to switch the target session and source. The problem is with missing objects - if object exists in target session but not in source it is not reported in the 'Differences' list.
Compare User Objects - need to run compare twice.
- Thread starter admin
- Start date
The compare user objects will indeed not drop objects in the target session, nor will it create objects in the source session.
About the compare user objects:
When I compare in PLSQLDev I get different packages (some missing some bogus), than if I use CSDiff on all exported objects (one file per object).
I do not know which one is correct, but (no offence) I have a feeling that CSDiff is more accurate.
When I compare in PLSQLDev I get different packages (some missing some bogus), than if I use CSDiff on all exported objects (one file per object).
I do not know which one is correct, but (no offence) I have a feeling that CSDiff is more accurate.
The Compare User Objects tool will only modify the target schema. An option to drop objects is on the list of enhancement requests.
Similar threads
- Discussion
- Discussion
- Locked
- Sticky
- Discussion