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:




    Private synonyms

    Stand-alone procedures

    Stand-alone stored functions


    Materialized views

    User-defined types

    Each of the following schema objects has its own namespace:




    Database triggers

    Private database links


    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



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


    Because the objects in these namespaces are not contained in schemas, these namespaces span the entire database.
  • 17. Re: Interesting Oracle Question
    jgarry Guru
    Currently Being Moderated
    Ah thanks, forgot all about that.

    Public synonyms are a classic way to [url]confuse people with name resolution.
1 2 Previous Next


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