Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    370

    Angry Unanswered: I can't create two FKs in a table

    Hi,

    When I want to create two foreign keys in a table my EM dies!It seems that it becomes inactive and only way I found is to disconnect from server and connect again!
    any suggestions plz?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Create FK's through SQL*Plus.

  3. #3
    Join Date
    Apr 2002
    Posts
    56
    You can always do it by hand, with TOAD or SQL+

    ALTER TABELE .... ADD CONSTRAINT etc.

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore,India
    Posts
    51
    may be your command is wrong...
    It doesn't happen so. It could happen if you have more than couple of hunderd GBs data and you trying to create now.
    Just say alter table table_name modify(column) reference parent_table.(parent_column)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •