This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Jan 4, 2013 2:53 PM by jgarry Go to original post RSS
  • 15. Re: Interesting Oracle Question
    jgarry Guru
    Currently Being Moderated
    Perhaps you should show where you are getting your definition of "namespace." I seem to have a broader definition than you.
  • 16. Re: Interesting Oracle Question
    Mark Malakanov (user11181920) Expert
    Currently Being Moderated
    Not a problem.

    >
    8. Within a namespace, no two objects can have the same name.

    The following schema objects share one namespace:

    Tables

    Views

    Sequences

    Private synonyms

    Stand-alone procedures

    Stand-alone stored functions

    Packages

    Materialized views

    User-defined types

    Each of the following schema objects has its own namespace:

    Indexes

    Constraints

    Clusters

    Database triggers

    Private database links

    Dimensions

    Because tables and views are in the same namespace, a table and a view in the same schema cannot have the same name. However, tables and indexes are in different namespaces. Therefore, a table and an index in the same schema can have the same name.

    Each schema in the database has its own namespaces for the objects it contains. This means, for example, that two tables in different schemas are in different namespaces and can have the same name.

    Each of the following nonschema objects also has its own namespace:

    User roles

    Public synonyms

    Public database links

    Tablespaces

    Profiles

    Parameter files (PFILEs) and server parameter files (SPFILEs)

    Editions

    Because the objects in these namespaces are not contained in schemas, these namespaces span the entire database.
    >
    http://docs.oracle.com/cd/E14072_01/server.112/e10592/sql_elements008.htm
  • 17. Re: Interesting Oracle Question
    jgarry Guru
    Currently Being Moderated
    Ah thanks, forgot all about that.

    Public synonyms are a classic way to [url http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7769752293246]confuse people with name resolution.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points