Last post May 24, 2012 03:03 AM by mishra.bhupesh
May 24, 2012 02:30 AM|mishra.bhupesh|LINK
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.
May 24, 2012 02:42 AM|Abhay Shah|LINK
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 .
May 24, 2012 03:03 AM|mishra.bhupesh|LINK
I was not sure about data thats why I asked it.Thanks.