top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
738 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?

...