Re: 2 DBA problems

Niall Litchfield wrote:

> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3DAAE675.3282437D_at_exesolutions.com...
> > s Lehaire wrote:
> >
> > > OK, thx, I'll try it.
> > >
> > > My problem is when We update our production server, today, we have to
> check
> > > all table for know wich have changed on the development server since the
> > > last update.
>
> <snip>
>
> >
> > Different question requiring a different answer.
> >
> > SELECT *
> > FROM all_tab_columns
> > WHERE owner = <owner_name>;
>
> There is a similar view for indexes all_ind_columns.
>
> Take a look at
> http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
> a76961/ch2.htm#136699 and you'll find more views than is healthy to
> remember.
>
> Having said all that I'd question why your developers don't have source
> control. They should be able to tell you what has changed.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************

And if they can't ... then one might inquire as to who, or what, is managing the development process?

Daniel Morgan Received on Mon Oct 14 2002 - 17:09:23 CDT