May I know that what is the need of sysnonyms? Can we create synonym for all the existing objects?
I need spendid answer which only vatern can provide us through their real time experience.
So please assist me here, thanks in advance.
ORA 01775 Looping Chains of Synonyms
Hi all, I am working on 8i, Linux. A developer recreated synonyms for tables in "user_tables" after doing he " select sysdate from dual; " gives in alert log ...
Tax Depreciation for all the existing Asset
The client was having only book depreciation configured. Recently we have also configure tax depreciation. I'm having a issues How do i get the tax depreciation for all the existing asset. When...
Deleting all objects from a tablespace
Just want to know what's the best way to delete all the objects (tables, indexes, squences, etc..) from a tablespace? Delete the tablespace and recreate it? Just drop the tables from the...
Trigger On Synonym
I have created synonym for remote database table in local database. Can I create trigger on synonym?