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
        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)
          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
            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