You can use RENAME for a stored PL/SQL program unit, public synonym, or cluster - Oracle Schema

Q.  You can use RENAME for a stored PL/SQL program unit, public synonym, or cluster. To rename such an object, there is no need to drop and re-create it.
- Published on 04 Aug 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - The above statement is false.

    - The true statement is:

    - "You cannot use RENAME for stored PL/SQL program unit, public synonym, index, or cluster. To rename such an object, you must drop and re-create it."

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