1 : create a database link bbetween the two instances
2 : use a minus
Select t.owner, t.table_name, t.column_name
from dba_tab_columns t, dba_objects o
Where t.table_name = o.object_name
And o.object_name = 'VIEW'
minus
Select t.owner, t.table_name, t.column_name
from [Email Address Removed] t, [Email Address Removed] o
Where t.table_name = o.object_name
And o.object_name = 'VIEW'
This will show you the columns missing on the other side.
Other columns of dba_tab_columns as needed.
Best regards
Olaf AHLERS, DBA
EIS - Basic Services
01 30 44 97 60
06 61 60 44 35
-----Message d'origine-----
De : Vivek Gupta
[mailto:oracledba-ezmlmshield-x54568152.[Email address protected]
Envoyé : vendredi 9 septembre 2005 10:45
À : LazyDBA Discussion
Objet : view comparision on two instances
Can any one help me to find all the view names which have different
definition on two separate instances.
Actually my requirement is. Suppose I have 100 views on one instance and
100 views with same name on another instance. Now I have to find out all the
view names out of these 100, which have different definition on two
instances.
TIA
Vivek Gupta
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Information transmitted by this EMAIL is proprietary to iGATE Group of
Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is
privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL
immediately notify the sender at iGATE or [Email address protected]
and delete this EMAIL including any attachments
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited and may be a
violation of law. If you received this transmission in error, please contact
the sender by reply e-mail and delete and destroy all copies of the
material, including all copies stored in the recipient's computer, printed
or saved to disk. Thank you.
Software virus: Europcar has taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own virus
checks on any attachment to this message. Europcar cannot accept liability
for any loss or damage caused by software viruses.
Intellectual Property: Europcar has built up a significant reputation in the
name "Europcar" and has a number of trademark applications and registrations
in many countries. No trademarks, service marks, and trade names owned or
licensed by Europcar or its affiliates may be copied, reproduced,
republished, uploaded, posted, transmitted, or distributed in any way,
without the prior written consent of Europcar.
Oracle LazyDBA home page