RE: SQL Developer dbdiff
Date: Tue, 5 Aug 2014 05:48:30 -0700 (PDT)
Message-ID: <1992b4e1-2894-4fde-9d32-5b7202af2e7c_at_default>
We use an APPS instance internally to regression test SQL Developer – so large schemas shouldn’t be an issue, although it will take awhile to run.
I imagine you asked to compare the contents of two schemas between instances…any idea of how many objects were to be included in the DIFF report?
Jeff
From: Patrice sur GMail [mailto:patrice.boivin_at_gmail.com]
Sent: Tuesday, August 05, 2014 8:17 AM
To: ORACLE-L
Subject: SQL Developer dbdiff
Well I tried db diff late last week to compare two instances.
The first time, the progress bar window had disappeared and there was nothing in the results pane. I thought I must have clicked on the X of the window without realizing it, killing the comparison.
On Friday I re-launched it, it ran and ran but after a few hours I saw the progress window disappear on its own. Nothing in the results pane. When I placed my cursor over the SQL Developer window, an hourglass appeared, but nothing else.
I left it running all weekend, it was a 3-day weekend here in Canada. I was hoping maybe it just needed time to render the results (?).
This morning, unfortunately, no change: no results, hourglass when the cursor is on the SQL Developer window.
Obviously this utility can't compare large databases. (I wouldn't say these two are large, they only have between 1000 and 2000 schemas). The old Java-based Enterprise Manager Change Manager was better than this. That one used to choke when run from a Windows server because the hardware couldn't handle the I/O, but it did work when run from a UNIX server. It even showed that TOAD placed a garbage character at the end of plsql objects, it was good.
I guess I will try running SQL Developer from a Unix machine, maybe it will run better on Unix hardware than from a 4-cpu Windows 7 workstation.
- Patrice
My profiles: HYPERLINK "http://www.facebook.com/home.php?#!/profile.php?id=100000206805521" \nFacebookHYPERLINK "http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9" \nLinkedInHYPERLINK "http://www.twitter.com/PatriceBoivin" \nTwitter
Signature powered by HYPERLINK "http://www.wisestamp.com/email-install" \nWiseStamp
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 05 2014 - 14:48:30 CEST