top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

If we delete the base table whether the synonym will exists or not?

+1 vote
370 views

If we delete the base table whether the synonym will exists or not? If we use that synonym what type of error we will get?

posted Oct 5, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
 
Best answer

The SYNONYM will be exists even though the Table was dropped.
If we use that synonym the following errors will come
ORA-00980: synonym translation is no longer valid
ORA-00903: invalid table name
ORA-04043: object SCOTT.T1 does not exist

answer Oct 6, 2015 by Arun Gowda
Similar Questions
0 votes

Can database trigger written on synonym of a table and if it can be then what would be the effect if original table is accessed

0 votes

Oracle:Can database trigger written on synonym of a table and if it can be then what would be the effect if original table were accessed?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...