Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: schema comparisons on different databases

RE: schema comparisons on different databases

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Mon, 20 Nov 2000 09:36:34 -0400
Message-Id: <10686.122484@fatcity.com> 





EZsql looks good, but it would be helpful if it saved database info in =
a


table, then let us compare the same database against that saved info =
after


we do major maintenance.



I need a tool that would let me take a snapshot before and after doing =
major


maintenance or db reorgs, then compares the two to see if everything is =
in


order.



Regards,


Patrice Boivin


Systems Analyst (Oracle Certified DBA)


Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO





E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20



	-----Original Message-----
	From:	Murali Vallath [SMTP:murali_vallath_at_hotmail.com]
	Sent:	Thursday, November 16, 2000 9:05 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	RE: schema comparisons on different databases

	If you have the change managment pack under OEM you could do the DB
diff=20
	option to compare. It does a pritty good job.






	>From: Alex Hillman <alex_hillman_at_physia.com>

	>Reply-To: ORACLE-L_at_fatcity.com

	>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

	>Subject: RE: schema comparisons on different databases

	>Date: Thu, 16 Nov 2000 13:40:57 -0800

	>

	>EZSQL has it. www.ezsql.net

	>

	>Alex Hillman

	>

	>-----Original Message-----

	>Sent: Thursday, November 16, 2000 12:36 PM

	>To: Multiple recipients of list ORACLE-L

	>

	>

	>All,

	>

	>I have been onto Embarcardero and this is now called Change

Manager.


	>

	>Regards

	>

	> > Lee Robertson

	> > Acxiom

	> > Tel: 	0191 525 7344

	> > Fax: 	0191 525 7007

	> > Email: lerobe_at_acxiom.co.uk

	> >

	>

	>

	>-----Original Message-----

	>Sent: 16 November 2000 15:55

	>To: Multiple recipients of list ORACLE-L

	>

	>

	>Embarcadero has a tool called schema manager, that does this pretty

well.


	>

	>-----Original Message-----

	>Sent: Thursday, November 16, 2000 10:36 AM

	>To: Multiple recipients of list ORACLE-L

	>

	>

	>

	>

	>Hi All,

	>

	>Hit me with shameless plugs here.

	>

	>

	>Anybody know of any tool/utility etc that will compare schema A on

instance


	>A with  Schema A on instance B.

	>Down to the nitty gritty details.

	>I Like all options

	>

	>

	>TIA

	>

	>

	>Jack

	>

	=




>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


	>De informatie verzonden met dit E-mail bericht is uitsluitend

bestemd voor


	>de geadresseerde. Gebruik van deze informatie door anderen dan de

	>geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,

verspreiding


	>en/of verstrekking van deze informatie aan derden is niet

toegestaan.


	>Ernst & Young staat niet in voor de juiste en volledige

overbrenging van de


	>inhoud van een verzonden E-mail, noch voor tijdige ontvangst

daarvan.


        =


>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


	>The information contained in this communication is confidential and

may be


	>legally privileged. It is intended solely for the use of the

individual or


	>entity to whom it is addressed and others authorised to receive it.

If you


	>are not the intended recipient you are hereby notified that any

disclosure,


	>copying,  distribution or taking any action in reliance on the

contents of


	>this information is strictly prohibited and may be unlawful. Ernst

&


	>Young is neither liable  for the proper and complete transmission

of the


	>information contained in this communication nor for any delay in

its


	>receipt.



        =


>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


	>

	>

	>

	>

	>

	>--

	>Please see the official ORACLE-L FAQ: http://www.orafaq.com

	>--

	>Author:

	>   INET: nlzanen1_at_ey.nl

	>

	>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

	>San Diego, California        -- Public Internet access / Mailing

Lists


=09

>--------------------------------------------------------------------


	>To REMOVE yourself from this mailing list, send an E-Mail message

	>to: ListGuru_at_fatcity.com (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).


	>--

	>Please see the official ORACLE-L FAQ: http://www.orafaq.com

	>--

	>Author: Michael Boligan

	>   INET: mboligan_at_healthvision.com

	>

	>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

	>San Diego, California        -- Public Internet access / Mailing



Lists


=09

>--------------------------------------------------------------------


	>To REMOVE yourself from this mailing list, send an E-Mail message

	>to: ListGuru_at_fatcity.com (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).


	>

	>

	>The information contained in this communication is

	>confidential, is intended only for the use of the recipient

	>named above, and may be legally privileged. If the reader

	>of this message is not the intended recipient, you are

	>hereby notified that any dissemination, distribution or

	>copying of this communication is strictly prohibited.

	>If you have received this communication in error, please

	>re-send this communication to the sender and delete the

	>original message or any copy of it from your computer

	>system.

	>--

	>Please see the official ORACLE-L FAQ: http://www.orafaq.com

	>--

	>Author: lerobe - Lee Robertson

	>   INET: LEROBE_at_acxiom.co.uk

	>

	>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

	>San Diego, California        -- Public Internet access / Mailing



Lists


=09

>--------------------------------------------------------------------


	>To REMOVE yourself from this mailing list, send an E-Mail message

	>to: ListGuru_at_fatcity.com (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).




	Murali Vallath
	Oracle Certified DBA
	http://www8.ewebcity.com/muralivallath/
	http://www.summerksyus.com/





=09

________________________________________________________________________=








        Get more from the Web.  FREE MSN Explorer download :
http://explorer.msn.com


	--=20
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	--=20
	Author: Murali Vallath
	  INET: murali_vallath_at_hotmail.com

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in


Received on Mon Nov 20 2000 - 07:36:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US