Answer Posted / 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

What is oracle rowcount?

1034

---

What is clustered table in Oracle?

1105

---

What privilege is needed for a user to create tables in oracle?

901

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4114

---

Please explain drop constraint oracle?

1026

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1788

---

How to connect the oracle server as sysdba?

1009

---

Explain the use of compress option in exp command.

964

---

What is bulk collect in oracle?

954

---

How to load a large xml file?

1002

---

What is an Oracle index?

1602

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5287

---

Can we store images in oracle database?

944

---

How to create lov dynamically at runtime & attach to text field?

1097

---

How to concatenate two text values in oracle?

1052

---