Re: Database analysis

From: Peter Barnett <pnbarne_at_shep.bcbso.com>
Date: Thu, 30 Nov 2000 08:59:06 -0800 (PST)
Message-Id: <10696.123332@fatcity.com>

This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools.

--0__=QDtUhUFn27Lu4g0aMx9Vuxw51aiEBzNJPvxQSZ0NsHx3K0MYjL9TN3RM Content-Type: TEXT/PLAIN; CHARSET=us-ascii

DBArtisan's change manager does not recognize locally managed tablespaces in 8i. This is expected to be fixed in their next release.

Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
pnbarne_at_regence.com

On Tue, 28 Nov 2000 Hannah.M.Doran_at_sb.com wrote:

>
>
> 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:
>
>
>

--0__=QDtUhUFn27Lu4g0aMx9Vuxw51aiEBzNJPvxQSZ0NsHx3K0MYjL9TN3RM

Content-Type: TEXT/PLAIN; CHARSET=iso-8859-1
Content-Transfer-Encoding: QUOTED-PRINTABLE
Content-ID: <Pine.3.89.10011300856.A21712_at_shep.bcbso.com>

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 Thu Nov 30 2000 - 10:59:06 CST