Drop a synonym - Using DROP SYNONYM statement - Oracle Views, Sequences, and Synonyms

Q.  Drop a synonym that is no longer required using DROP SYNONYM statement. To drop a private synonym, omit the PUBLIC keyword. To drop a public synonym, include the PUBLIC keyword.
- Published on 12 Aug 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 29 Sep 15
    - You can drop any private synonym in your own schema.

    - To drop a private synonym in another user's schema, you must have the DROP ANY SYNONYM system privilege.

    - To drop a public synonym, you must have the DROP PUBLIC SYNONYM system privilege.

    - Drop a synonym that is no longer required using DROP SYNONYM statement.

    - To drop a private synonym, omit the PUBLIC keyword.

    - To drop a public synonym, include the PUBLIC keyword.

    - For example, the following statement drops the private synonym named emp:

    DROP SYNONYM emp;

    - The following statement drops the public synonym named public_emp:

    DROP PUBLIC SYNONYM public_emp;

    - When you drop a synonym, its definition is removed from the data dictionary.

    - All objects that reference a dropped synonym remain.

    - However, they become invalid (not usable).

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)