Murtuja wrote:
> Hi
> I have two databases.Both are same.Now I want to compare both databse
> by each and every objects like
> tables
> constraint
> index
> trigger
> procedures
> package
> view
> sequence
> How can I find out differcences from two database?
> Can u provide me script for that?
- Create a database link
- SELECT object_name, object_type, 'LOCAL'
FROM dba_objects
MINUS
SELECT object_name, object_type, 'LOCAL'
FROM dba_objects_at_remote
UNION ALL
SELECT object_name, object_type, 'REMOTE'
FROM dba_objects_at_remote
MINUS
SELECT object_name, object_type, 'REMOTE'
FROM dba_objects;
and then against dba_constraints local and remote or UNION ALL
in the result set.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Dec 21 2005 - 11:09:31 CST
