At 11:04 2003-06-17 -0800, you wrote:
TOAD v7.5 will allow you to "export" INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run "sdiff -s" between the files in order to get the differences. Yes, it's a bit "manual", but the price is right (ours was <$350/copy back in the 1900s). You can evaluate TOAD by filling out the contact form at:
http://www.quest.com/toad/
...and click on the "Download Trial" link on the left.
HTH!
Rich
Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> -----Original Message----- > From: Stephen Lee [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 1:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare Schema with data > > > > I think DB Artisan Change Manager will do it. > > > -----Original Message----- > > Is any body know any tools for comparing two schema for only > > data comparison > > & create script for the result > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: [EMAIL PROTECTED]
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).