Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Provided Answers: 1

    Unanswered: Textbook error? Just curious...

    My Oracle text book (Oracle9i Database Administrator, by Carol McCullough-Dieter) states that views starting with DBA require the owner, SYS, as a prefix, and gives this example:

    select table_name, column_name
    from sys.dba_tab_columns
    where rownum < 200

    ...but this code runs just fine on my machine and produces the same results:

    select table_name, column_name
    from dba_tab_columns
    where rownum < 200

    So is my text book incorrect?
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >So is my text book incorrect?
    It depends upon which user is logged in & doing the SELECT
    Read Chap. 22 & 23
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2004
    That used to be more common in older versions of Oracle. The db create scripts would sometimes fail, or just weren't called. The dba views have public synonyms created for them, but select on the views is only granted to the DBA role, you don't need the "SYS." prefix. And if you did, you could just find the script to create the public synonyms.

Posting Permissions

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