10, 2002 1:20 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Database Comparison
Srini,
Use the change manager that comes with Oracle Enterprise manager. The
initial set-up is little bit difficult. But once u r through, then it is an
handy tool.
Venkat
--
--
Please see
, January 10, 2002 1:20 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Database Comparison
Srini,
Use the change manager that comes with Oracle Enterprise manager. The
initial set-up is little bit difficult. But once u r through, then it is an
handy tool.
Venkat
--
On Wed, 09
www.netcraft.com
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is
Srini,
But be careful - the Change Management pack for OEM is a purchaseable
option. It is not free.
Jim
__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise
Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis,
recipients of list ORACLE-L
Subject: Re: Database Comparison
Srini,
Use the change manager that comes with Oracle Enterprise manager. The
initial set-up is little bit difficult. But once u r through, then it is an
handy tool.
Venkat
--
--
Please see the official ORACLE-L FAQ: http
Srini,
I would suggest going to http://www.toadsoft.com and downloading the
freeware version in order to use the Schema Compare tool. All it would
require would be a database link between your Production DB and your QA DB,
or vice-versa. It will show you all object differences.
Jim
Srini
I agree with James. Free tool does a pretty good job. I question it's
report of db triggers and views, though. Doesn't seem to be right - it
always reports them out of sync for me.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, January 09,
There's a very good script available at http://www.dbspecialists.com.
--- [EMAIL PROTECTED] wrote:
Hi:
I need to compare my Production database with QA database. I would
like to
generate a report that shows differences in schemas across these two
databases(tables, indexes, views, object
Srini,
Use the change manager that comes with Oracle Enterprise manager. The initial set-up
is little bit difficult. But once u r through, then it is an handy tool.
Venkat
--
On Wed, 09 Jan 2002 11:00:36
Paul Baumgartel wrote:
There's a very good script available at