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
- 8882 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 do I limit the number of rows returned by an oracle query after ordering?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is query image?
How do I spool to a csv formatted file using sqlplus?
Explain compound trigger in oracle?
13. Display the second to fifth characters in each client name.
How to connect to a remote server?
What does `(+)` do in a where clause?
How can I combine multiple rows into a comma-delimited list in oracle?
how to delete all duplicate records from a table using subquery?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How do I uninstall oracle 11g?
Oracle General 
