Interested to Buy Any Domain ? << Click Here >> for more details...
You create a private database link and upon connection,
fails with: ORA-2085: connects to . What is the problem? How
would you go about resolving this error?
- 1 Answers
- 8931 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
SQL> select * from all_catalog@tg4msql_v91;
select * from all_catalog@tg4msql_v91
*
ERROR at line 1:
ORA-02085: database link TG4MSQL_V91.DE.ORACLE.COM
connects to HO.WORLD
Resolution:
This problem is related to GLOBAL NAMES.
The simplest way to disable global naming is to alter
the current session.
alter session set global_names=false;
The other solution is to add a global_name to the
gateway/hs:
HS_DB_NAME = <datasource>
HS_DB_DOMAIN = <DOMAIN>
But the HS_DB_NAME must not exceed 8 characters and
must not contain any extra characters. If this is not
possible, the globale naming can be disabled by setting
GLOBAL_NAMES = FALSE in the init.ora of the database
as well
| Is This Answer Correct ? | 0 Yes | 0 No |
How to use regular expression in pattern match conditions in oracle?
What is PL/SQL ?
Explain rename?
Do View contain Data ?
How to create a server parameter file?
What is an external table?
what is trigger?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
How to find the date and time of last updated table?
how many columns can a plsql table have
What are the roles of dba?
Oracle General 
