CREATE SYNONYM command

http://www-eleves-isia.cma.fr/documentation/OracleDoc/CREATE-SYNONYM.html

PURPOSE:
    To create a synonym.  A synonym is an alternative name for a table,
    view, sequence, procedure, stored function, package, snapshot, or
    another synonym.

SYNTAX:

CREATE [PUBLIC] SYNONYM [schema.]synonym
    FOR [schema.]object[@dblink]

where:

PUBLIC
    creates a public synonym.  Public synonyms are accessible to all
    users.  If you omit this option, the synonym is private and is
    accessible only within its schema.

schema
    is the schema to contain the synonym.  If you omit schema, Oracle
    creates the synonym in your own schema.

synonym
    is the name of the synonym to be created.

FOR
    identifies the object for which the synonym is created.  If you do
    not qualify object with schema, Oracle assumes that the object is in
    your own schema.  The object can be of these types:

          * table
          * view
          * sequence
          * stored procedure, function, or package
          * snapshot
          * synonym

    The object cannot be contained in a package.  Note that the object
    need not currently exist and you need not have privileges to access
    the object.

    You can use a complete or partial dblink to create a synonym for an
    object on a remote database where the object is located.  If you
    specify dblink and omit schema, the synonym refers to an object in
    the schema specified by the database link.  Oracle Corporation
    recommends that you specify the schema containing the object in the
    remote database.

    If you omit dblink, Oracle assumes the object is located on the
    local database.

PREREQUISITES:
    To create a private synonym in your own schema, you must have CREATE
    SYNONYM system privilege.

    To create a private synonym in another user's schema, you must have
    CREATE ANY SYNONYM system privilege.  If you are using Trusted
    Oracle in DBMS MAC mode, your DBMS label must dominate the creation
    label of the owner of schema to contain the synonym.

    To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM
    system privilege.

评论

1 楼 anttu 2012-03-19