Re: Creating Oracle constraints across schemas

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Apr 20 2006 - 12:14:04 EDT

  • Next message: Chris Poulsen: "Re: Creating Oracle constraints across schemas"

    On Apr 20, 2006, at 7:55 PM, Mike Kienenberger wrote:

    > I notice that the modeler is unable to create a constraint across a
    > schema, even when the two schemas are in the same database. Is this
    > to be expected?

    Yes. I don't think the RDBMS supports that (as the error below
    suggests).

    > If so, should the modeler stop generating these kinds
    > of statements?
    >
    > [SQL: ALTER TABLE ENG_WORK_MGMT.ENG_WORK ADD FOREIGN KEY (ENG_WORK_ID)
    > REFERENCES CORE_WORK_MGMT.STATUSABLE_WORK (ID)] - ORA-00942: table or
    > view does not exist

    Yeah, it should. There is currently a filter somewhere
    (DbGenerator??) that prevents FKs to be generated across DataNodes.
    Probably need to extend that to also check for different schemas in
    the same DataMap.

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 12:14:31 EDT