Results 1 to 2 of 2

Thread: schema

  1. #1
    Join Date
    Nov 2002

    Unhappy Unanswered: schema

    when a user in oracle, say user Db100, issues
    "select * from tblAbc",
    how does the oracle engine figures out which "tblABC" to read from?


  2. #2
    Join Date
    Jul 2003
    couple rules:
    #1 Oracle assumes the current user is the owner
    #2 If current user does not have a table with that name, then Oracle checks for public synonyms
    #3 If no ownership or synonym exists, then you need to specify the owner before the tablename.

    ie: I am User/schema "DUCK" and I want to look at the EMP table owned by user/schema "SCOTT"

    PHP Code:
    sid-DUCKselect from scott.EMP
    We are also assuming that as "DUCK" I have privileges which will allow me to select tables owned by "SCOTT"
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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