plsql developer has a great compare tool also for those of you who use
windows.

Stacy

On Friday 09 September 2005 4:44 am, Vivek Gupta wrote:
> 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

--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.[Email address protected]

Oracle LazyDBA home page