Re: 2 DBA problems

"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
******************************************