Database Compare Script

I am looking for a script to compare an entire database instance against another. (From system_at_instance, etc).  

I do not want something that has to be done by schema, as I have 50+ schema's to compare.      

ALSO - on a side note, is there an 'easy' way of duplicating a PRODUCTION database over to test, without copying the db files?  

---

Michael E. Cupp, Jr.

**** Email:       michael.cupp_at_wpafb.af.mil



** Phone:     937-255-1982         DSN 785-1982




** Fax:         937-656-4308         DSN 986-4308




** Location:    DET 1 AFRL/WSI


                           Bldg 45, Room 062

                           2130 8th St

                           WPAFB OH 45433

 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cupp Michael E Contr Det 1 AFRL/WSI
  INET: Michael.Cupp_at_wpafb.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).