DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Foreign Key on another schema ?

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Foreign Key on another schema ?

    Is it possible to create a table tabA in SchemaA that has a foreign key that References a field in tabB in SchemaB?

    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    yes. it says so in the documentation
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Are any special privileges required ?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    yes. it says so in the documentation
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    thanks .... you've been great help !

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by khussain
    thanks .... you've been great help !
    The documentation can also be of great help.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

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


Click Here to Expand Forum to Full Width