Re: Using Schema Diff in SQL Developer - fails to function

From: <sybrandb_at_hccnet.nl>
Date: Tue, 05 Jun 2007 20:51:43 +0200
Message-ID: <k1cb63t6fbc1b8h75n544o67vmd156k083_at_4ax.com>


[Quoted] On Tue, 05 Jun 2007 11:40:24 -0700, oaksong <oaksong_at_hotmail.com> wrote:

>I'm trying to compare two database schemas with Schema Diff in Oracle
>SQL Developer. It worked, once. I've not been able to get it to work
>again. It reports no errors and it does nothing. That is, the feed
>back bar pops up and slides across a couple times then puts me on the
>output tab, which is empty.
>
>Any suggestions would be appreciated.
>
>Details:
>I'm mapped to two versions of my database, development and production.
>I'm trying to generate a script to update production to look like
>development. The one time the Schema Diff ran and produced output I
>got all of the necessary script to perform the changes.
>
>The script was run, but generated quite a few errors. At this point it
>would save a lot of time if I could get the Diff engine to produce a
>script that I could review and run in pieces. While I can view the
>schema components via the SQL Developer interface, the Diff engine
>fails to perform.
>
>tia
>Chris

According to my dictionary 'fail' can have multiple meanings. My crystall ball doesn't manage to see what failure you have. Also, do those Oracle databases by any chance have version numbers inscribed on their shirts?
Care to share them?

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jun 05 2007 - 20:51:43 CEST

Original text of this message