Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I find out differcences from two database?
The commercial version of Toad has a nice utility for that.
Oracle Designer also has a utility for that.
Other than that the fastest poor man solution is:
exp ... full=y file=anything *rows=n*
on both databases
and
imp .. full=y show=y log=<any file>.log
and run diff on both output files.
But then of course if you have version control in place you wouldn't need this.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Dec 21 2005 - 04:19:17 CST
![]() |
![]() |