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
Received on Wed May 09 2007 - 06:16:18 CDT
