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

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1 Answers   GTL,

---

How to speed up webrick?

1 Answers  

---

Which are the five query types available in oracle?

1 Answers  

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1 Answers   Oracle,

---

How can we find out the current date and time in oracle?

1 Answers  

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

How to upsert (update or insert into a table)?

1 Answers  

---

Why oracle is used?

1 Answers  

---

How to export data with a field delimiter?

1 Answers  

---

how many types of index?

2 Answers   Cap Gemini, TCS,

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

1 Answers   TCS,

---

Why do we use bulk collect in oracle?

1 Answers  

---