Re: Compare table structures between two schema

Hi
OEM 9i has it all.

Thanks,
Ashok

"Dirk Tschentscher" <dirkTHIS_at_REMOVEvolkswagen.de> wrote in message news:<bhvo0o$fpn2_at_doiweb4.wob.vw.vwg>...
> Hello
>
> You may use the compare schema function from toad ?
>
> Rgds
> Dirk
> "Jayaraman Ashok" <ashok_jayaraman_at_yahoo.com> schrieb im Newsbeitrag
> news:7ca2852.0308192217.65d42a2c_at_posting.google.com...
> > Hi
> > I am maintaining a customized Oracle 11.5.4 setup. I would like to
> > know what tables and objects have been modified from the base or
> > standard 11i setup. I plan to achieve this by comparing the customized
> > setup with another standard 11.5.4 setup by using the dba_tab_columns
> > where i will get to know the columns,datatypes,length/precision etc.
> > Can somebody guide me as to how to go about it ? Do i take the output
> > into a flat file and then import into excel to compare or can i write
> > a shell script that can compare the outputs and give the differing
> > tablename/columnname etc. Either case give me some hints.
> >
> > Thanks,
> > Ashok
Received on Thu Aug 21 2003 - 00:59:56 CDT