Re: Database analysis

From: <Hannah.M.Doran_at_sb.com>
Date: Tue, 28 Nov 2000 12:34:54 -0500
Message-Id: <10694.123097@fatcity.com>

--0__=QDtUhUFn27Lu4g0aMx9Vuxw51aiEBzNJPvxQSZ0NsHx3K0MYjL9TN3RM
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

try http://www.embarcadero.com. they have lots of cool tools. I have only worked with DBArtisan, but check out their site. Sorry nothing more definitive:>

Hannah

"Taylor, Shirley" <TaylorSI_at_mar.dfo-mpo.gc.ca> on 11/28/2000 09:05:50 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Database analysis

--0__=QDtUhUFn27Lu4g0aMx9Vuxw51aiEBzNJPvxQSZ0NsHx3K0MYjL9TN3RM

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

We're looking for software which will help us to compare the state of a= ll
database objects before and after full export. We want to be able to ru= n a
program to gather info on schemas and objects that can then be used in automated validation routines after backup restorations and imports, fo= r
example: total count of tables by schema and row counts, status of ind= ices,
views, procedures, etc., current/next sequence value, etc. Ideally, we'= d
like to get a snapshot of the whole database before and after and produ= ce a
report to pinpoint differences. Any ideas?

Thanks,
Shirley
Systems Admin & Operations | Admin. et Expoit. des syst=E8ms

Technology Services           | Services technologiques
Informatics Branch       | Direction de l'informatique

Maritimes Region, DFO | R=E9gion des Maritimes, MPO St. Andrews, N.B., Canada
ph: (506)529-5911
fax:(506)529-5862
taylorsi_at_mar.dfo-mpo.gc.ca

--

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

Author: Taylor, Shirley
INET: TaylorSI_at_mar.dfo-mpo.gc.ca

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 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). Received on Tue Nov 28 2000 - 11:34:54 CST