1 Reply Latest reply: Jul 29, 2014 12:30 PM by clcarter RSS

    Problem with alter

    im99_chs

      Good afternoon to all

      I try to run the code below in XE 11

      alter table CUSTOMERS

        add constraint CUSTOMERS_ACCOUNT_MANAGER_FK foreign key (ACCOUNT_MGR_ID)

        references HR.EMPLOYEES (EMPLOYEE_ID) on delete set null;

       

      the result is

      Error report -

      SQL Error: ORA-01031: insufficient privileges

      01031. 00000 -  "insufficient privileges"

       

      Thanks in advance

      Christos