Oracle Foreign Keys Questions and Answers

Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

Oracle foreign key problem with different schema

Reference when object not exist in same schema. Software/Hardware used: oracle

View Answer   |  Aug 21 2009  3:34 AM GMT
Oracle, Oracle foreign keys
asked by Webtechsolutions

  45 pts.

ORA-01031 Insufficient privileges

I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

View Answer   |  Jun 16 2009  6:51 AM GMT
ORA-01031, Foreign keys, Primary keys
asked by SRDBA

  5 pts.

1 - 2 of 2
<<PREVIOUS 1 NEXT>>