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

Thread: Foreign Key on another schema ?

  1. 04-30-2003, 11:17 AM #1
    khussain
    khussain is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 04-30-2003, 11:32 AM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
  3. 04-30-2003, 11:43 AM #3
    khussain
    khussain is offline Senior Member
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Are any special privileges required ?
    Reply With Quote Reply With Quote
  4. 04-30-2003, 11:44 AM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    yes. it says so in the documentation
    Jeff Hunter
    Reply With Quote Reply With Quote
  5. 04-30-2003, 11:48 AM #5
    khussain
    khussain is offline Senior Member
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    thanks .... you've been great help !
    Reply With Quote Reply With Quote
  6. 05-01-2003, 09:12 AM #6
    julian
    julian is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width