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
- 9046 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 get the no employee in each department including the dept which has 0 employee
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
How to start instance with a minimal initialization parameter file?
How many file formats are supported to export data?
Why is oracle database so popular?
The join defined by the default data link is an outer join yes or no ?
What is the CAP theorem?
What is the difference between primary key and unique key and foreign key in oracle?
What is an oracle function?
How to convert a date to char in oracle? Give one example.
What are the ansi data types supported in oracle?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
Oracle General 
