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.
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...
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...
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 ...
Trigger On Synonym
I have created synonym for remote database table in local database. Can I create trigger on synonym?