Topic
  • 3 replies
  • Latest Post - ‏2010-01-22T17:45:10Z by Ivan_CA
SystemAdmin
SystemAdmin
33 Posts

Pinned topic ODA Change Management Editor error

‏2010-01-22T14:07:01Z |
Hello,
Using ODA v2.2.2 on Linux, I can't add a foreign key on a newly created table using the Change Management Script Editor.
After table is created, using the Add Object button, doesn't show the list of objects type, so I can't a Foreign key or anything else.

Any clue on this ??
Is this a Linux ONLY behavior or you get it on Windows as well ?

Getting worried about productivity using the tool.

Thanks for your help.
Updated on 2010-01-22T17:45:10Z at 2010-01-22T17:45:10Z by Ivan_CA
  • MichaelZuliani
    MichaelZuliani
    2 Posts

    Re: ODA Change Management Editor error

    ‏2010-01-22T17:22:33Z  
    I'm not sure why your Add Object list is completely empty.
    See attached screen shot to see what objects are normally listed.
  • MichaelZuliani
    MichaelZuliani
    2 Posts

    Re: ODA Change Management Editor error

    ‏2010-01-22T17:24:19Z  
    However, even for me Foreign Keys aren't in that list.

    You can add a foreign key with the Change Management Script Editor (CMSE) by starting in the Data Source Explorer (DSE).

    IWith the DSE n Hierarchical presentation mode (not flat presentation mode), drill down to the Constraints folder and select the Create -> Foreign key menu option. See attached screen shot.
    You'll be asked if you want to use the CMSE or Data Object Editor. If you pick CMSE, the new foreign key will appear in the CMSE.

    <connection>
    + <database>
    + Schemas
    + <schema>
    + Tables
    + <table>
    Constraints
  • Ivan_CA
    Ivan_CA
    2 Posts

    Re: ODA Change Management Editor error

    ‏2010-01-22T17:45:10Z  
    However, even for me Foreign Keys aren't in that list.

    You can add a foreign key with the Change Management Script Editor (CMSE) by starting in the Data Source Explorer (DSE).

    IWith the DSE n Hierarchical presentation mode (not flat presentation mode), drill down to the Constraints folder and select the Create -> Foreign key menu option. See attached screen shot.
    You'll be asked if you want to use the CMSE or Data Object Editor. If you pick CMSE, the new foreign key will appear in the CMSE.

    <connection>
    + <database>
    + Schemas
    + <schema>
    + Tables
    + <table>
    Constraints
    Hi Michael,

    In the "Add Objects", after you select "Constraints" and click "Create", you will choose what kind of constraint to create.

    Please see screenshot addobjectsfk.jpg.

    I'm using ODA 222 on SUSE Linux 10 x86_64 by the way.

    Thanks,
    Ivan