Re: SQL Developer dbdiff

From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Tue, 5 Aug 2014 10:04:44 -0300
Message-ID: <CACH2EDLKqrh=2ymRFNQ9qEUGRNp=DGkh5vgP3zV79q=HwzGu7w_at_mail.gmail.com>

not two schemas, between 1000 and 2000 schemas.

db diff

On Tue, Aug 5, 2014 at 9:48 AM, Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> 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: [image: Facebook]
> <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
> LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
> Twitter] <http://www.twitter.com/PatriceBoivin>
>
>
>
> Signature powered by WiseStamp <http://www.wisestamp.com/email-install>
>

-- 


-- Patrice
My profiles: [image: Facebook]
<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
Twitter] <http://www.twitter.com/PatriceBoivin>
 <http://www.twitter.com/PatriceBoivin>
Signature powered by WiseStamp <http://www.wisestamp.com/email-install>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 05 2014 - 15:04:44 CEST