locked
Drop Synonym. RRS feed

  • Question

  • User143067745 posted

    I am using Oracle. I have a table named tbl1 in database1. I created synonym of tbl1 in another database database2 with same name. How to drop this synonym in database2 without affecting data of database1. Please be sure that original table(tbl1) in database1 should not be affected.

    Thursday, May 24, 2012 2:30 AM

Answers

  • User-1264638846 posted

    Hey,

    Go to a second database and simply apply drop Synonym statement / command.  

    I don't see any issue of remove original table with drop Synonym statement .

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 24, 2012 2:42 AM

All replies

  • User-1264638846 posted

    Hey,

    Go to a second database and simply apply drop Synonym statement / command.  

    I don't see any issue of remove original table with drop Synonym statement .

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 24, 2012 2:42 AM
  • User143067745 posted

    I was not sure about data thats why I asked it.Thanks.

    Thursday, May 24, 2012 3:03 AM