Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Location
    Omaha
    Posts
    3

    Unanswered: What are objects and system tables in Oracle?

    These terms are confusing to a new Oracle users.

    I searche google but all I found was the Oracle FAQ Glossary

    http://www.orafaq.com/glossary/faqgloss.htm

    What is an object in Oracle?

    What are system tables and what do they do in Oracle?

    thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    RTFM "Concepts Manual" found at http://tahiti.oracle.com
    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
    Sep 2004
    Location
    London, UK
    Posts
    565
    I don't think "system table" is a term widely used in the Oracle documentation. Perhaps it is sometimes used to refer to tables that form part of the Oracle installation. What context have you heard it used in?

    "Objects" can refer loosely to anything in the database, particularly in the context of schema objects, i.e. anything that might be found in a schema (tables, indexes, views, whatever). It can also be used in a more specific OO sense to refer to instances of object types.

  4. #4
    Join Date
    May 2006
    Location
    Omaha
    Posts
    3
    Quote Originally Posted by WilliamR
    I don't think "system table" is a term widely used in the Oracle documentation. Perhaps it is sometimes used to refer to tables that form part of the Oracle installation. What context have you heard it used in?
    Just searching Google with 'Oracle System Tables' turns up results, for example, the first one

    http://www.techonthenet.com/oracle/sys_tables/index.php

  5. #5
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Those are more commonly called Data Dictionary Views.

Posting Permissions

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