| plz help.Object comparision [message #62992] |
Tue, 31 August 2004 04:29  |
Anu
Messages: 82
Registered: May 2000
|
Member |
|
|
Hi!
I have two oracle database with two different versions. One is in 8.1.6 and another on is in 9.2.0.
I need to compare all the Schema objects( i mean, structures of tables, views, triggers etc). could any body please help me in this regard?
regards,
anu
|
|
|
|
| Re: plz help.Object comparision [message #62993 is a reply to message #62992] |
Tue, 31 August 2004 04:59  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi
this you can do it 2 ways
1)create a database link between the databases and
grant a select_catalog_role privilige to 2 users
of different databases and write set operator query
using a database link
2)this is manual spool out your output to a file
and write a query on two databases to get objects
information of each database and compare manually in
spool file
Regards
D.Dilip
|
|
|
|
| Re: plz help.Object comparision [message #62994 is a reply to message #62993] |
Tue, 31 August 2004 05:33 |
Anu
Messages: 82
Registered: May 2000
|
Member |
|
|
Hi!
thanks for reply. But in my problem each of the databases contain around 1800 tables. so the said solution consumes much time. i am not in a position do invest that much time.
could you please suggest another solution
anu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
