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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to compare DB Tables in different Instances - MORE OPTIONS

Re: How to compare DB Tables in different Instances - MORE OPTIONS

From: <satar_at_my-dejanews.com>
Date: 1998/10/17
Message-ID: <708uuu$ijl$1@nnrp1.dejanews.com>#1/1

Why not just export each database (without data) and import with the "list contents" option. then you can compare the imports for tables, indexes, procedures, ect..
I think the only thing you will be missing is the refrential constraints. Anyone want to comment on this?
Satar

In article <706k3p$h25$1_at_supernews.com>,   "Jeff Keen" <No_Spam_at_For_Me.com> wrote:
> Check out TOAD (www.toadsoft.com).
> It has a compare schema feature... great tool, and FREE!
>
> Paul Chu wrote in message <3624CBEE.E869A19B_at_earthlink.net>...
> >Martin,
> >
> >Thanks for the reply.
> >I'm really looking for a convenient way to compare the Schema of two DB
 instances
> >to insure that we detect any DB changes between an In-house Development DB
 and a
> >Client Version (deployed version) of the same DB. We would like a way to
> >compare by connecting to both DBs.
> >
> >Is there a way to compare the DB schema and list descrepancies via a
> >SQLPLUS script ? by reading user_tab_columns in each instance ?
> >Can a script connect to both DB's and do the compare ?
> >
> >Or is there an Oracle utility which can do this ?
> >
> >Alternatively, I may consider a data modeling tool such as ERWIN
 (synchronization
> >feature) or POWERDESIGNER to load the Development Data Model and
> >compare to the Client DB Instance Data Model.
> >
> >Regards, Paul
> >
> >replace this with @ wrote:
> >
> >> Hi,
> >>
> >> >We have a need to compare the data in tables in a base Instance
> >> >with the new DB instance thats created for a Client.
> >>
> >> I'm thinking about a database link, but don't know if this is correct.
> >>
> >> >Request suggestions on how to automate comparing tables
> >> >and possibly listing descrepancies.
> >>
> >> I don't know if it's possible to create triggers between instances. It
> >> sure isn't recommended for performance.
> >>
> >> But of course you can use sql-statements to list the discrepancies.
> >> Maybe you even want to create a generic script using the
> >> user_tab_columns table.
> >> -------------------------------------------------------------------------



> >> --- Martin Jesterhoudt
> >> --- martinj(replace this by @)xs4all.nl
> >> -------------------------------------------------------------------------


> >
> >
> >
>
>
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Sat Oct 17 1998 - 00:00:00 CDT

Original text of this message

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