Re: Compare Tables Tool?

Don't know if Oracle provide a tool but various 3rd parties do. I'm evaluating Schema Manager from Quest software - 30day trial verrsion are available off the web. This does some of what you are looking for.

In article <3560CD5D.D8CB031_at_nospam.amp.com.au>,   rowan_mccammon_at_nospam.amp.com.au wrote:
>
> Hi All,
>
> Wondering if there is anything around which if given two tables of the exact
> same structure will produce a text file with the SQL statements to make them
> both the same.
>
> For example:
>
> Consider two schemas, BEFORE and AFTER, with the same structures. Both contain a
> table, TABLE1 of the following structure:
>
> TABLE1 ( ID, NAME )
>
> Example 1:
>
> BEFORE.TABLE1 ( ID, NAME ) = '1', 'Simon'
> AFTER.TABLE1 ( ID, NAME ) = '1', 'Simon Moy'
>
> DIF: UPDATE TABLE1 SET NAME = 'Simon Moy' WHERE ID = '1'
>
> -----
> Example 2:
>
> BEFORE.TABLE1 ( ID, NAME ) =
> AFTER.TABLE1 ( ID, NAME ) = '2', 'Leo Ng'
>
> DIF: INSERT INTO TABLE1 ( ID, NAME ) VALUES ( '2', 'Leo Ng' )
>
> -----
> Example 3:
>
> BEFORE.TABLE1 ( ID, NAME ) = '3', 'Russell Pegler'
> AFTER.TABLE1 ( ID, NAME ) =
>
> DIF: DELETE FROM TABLE1 WHERE ID = '3'
>
> ---------
>
> To repeat above: Does Oracle supply a tool which can output the differences
> between the two schemas in SQL terms (see example below)?
>
> And if so...
> Can the tool be configured to automatically update the 'BEFORE' view after
> creation of the differences?
> Does the tool work with LONG fields?
> Can the tool examine all required tables and columns across two schemas based on
> some input definition?
>
> Any help on this appreciated.
>
> Regards,
> Rowan McCammon.
>
> --
> Remove the anti-spamming thingy from my email address to reply to me.
>
> The opinions expressed are my own and do not represent the opinions
> of my company.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 00:00:00 CEST