Home     |     Java    |     Php General    |     Oracle Database    |     Oracle Server  

MS Dynamics CRM 3.0

  •  Setting up and Configuring Microsoft Dynamics CRM 3.0
  •  Managing Security and Information Access
  •  Entity Customization: Concepts and Attributes
  •  Entity Customization: Forms and Views
  •  Entity Customization: Relationships, Custom Entities, and Site Map
  •  Reporting and Analysis
  •  Workflow
  •  Server-Side SDK
  •  Client-Side SDK
  •  Integration with External Applications

    • Cervo Technologies
    The Right Source to Outsource

    Sharepoint Portal Server KB

    Microsoft CRM Info

    WPF Interview Questions

    SilverLight Interview Qs

    Asp.Net 2.0 Interview Qs

    Asp.NET 1.1 FAQs

    Oracle Interview Questions

    SAP Interview Questions

    Oracle Database

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


    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

    On May 9, 10:40 am, Tarby777 <nick_william@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

    -----------------------------------------------Reply-----------------------------------------------

    On May 9, 4:16 am, sybrandb <sybra@gmail.com> wrote:

    Pretty scary.  That was bug 2474106 fixed in 9203.

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

    Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc