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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with comparing two databases (a newbie? question)

Re: Help with comparing two databases (a newbie? question)

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 25 Aug 2004 22:54:10 -0700
Message-ID: <1093499702.804723@yasure>


Andrzej wrote:

> Hello,
>
> I need to compare two databases/schemas from different servers. Unfortunately
> the database names are the same. Does anybody know how to do it using OEM?
> Oracle wants to have different database names.
> I'm using Oracle 9i 9.2.0.5.
>
> Thank you for any help.
>
> Andrzej Urbanowicz

Create a database link.
Subtract the local user_objects from the remote user_objects and visa versa.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Aug 26 2004 - 00:54:10 CDT

Original text of this message

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