Re: Sys.dba_tables.compression missing in 9.2.0.8 database - why?

On May 9, 4:16 am, sybrandb <sybra..._at_gmail.com> wrote:
> On May 9, 10:40 am, Tarby777 <nick_william..._at_mentorg.com> wrote:
>
> > Hi all,
>
> > Why would one 9.2.0.8 database have a column named "compression" in
> > SYS.DBA_TABLES and another one not? That's the situation I have... I'm
> > trying to work with a colleague's database and my 3rd party schema
> > comparison / fix utility is expecting the column to be there, and
> > crashing out because it isn't...
>
> > Running "desc" on my SYS.DBA_TABLES and his SYS.DBA_TABLES shows that
> > the views are the same apart from this one difference.
>
> > TIA
> > Tarby
>
> One likely reason would be the database haven't been patched to
> 9.2.0.8 using the same procedure.
> Maybe on one of those databases catpatch.sql wasn't run.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Pretty scary. That was bug 2474106 fixed in 9203.

jg

--
@home.com is bogus.
http://ask.slashdot.org/askslashdot/07/05/09/1728252.shtml