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?
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
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
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?