DBLINK

HOW TO COPY DBLINKS FROM ONE DATA BASE TO OTHER DATABASE,I MEAN I NEED TO CREATE XX DBLINK FROM ORACLE8I TO ORACLE9I.
HOW I LOOK SOURCECODE FOR THAT DBLINK?
THANKS
KAVITHA

read the manuals
it's free in case you dont know

:D :D :D

If someone asks question or puts question in this forum guys u need to answer instead of sending ur expert comments on it.


Gayatri selvarajan

I KNOW DEAR FRIENDS
BUT I AM VERY BUSY WITH WORK SCHEDULE.
THANKS

From 8i database schema owner with privileges 'create database link'

CREATE DATABASE LINK "XX" CONNECT TO "9idb_sch_owner" IDENTIFIED BY "*****" USING '8idb_to_9idb';

where 8idb_to_9idb is service name registered with 8i tnsnames.ora pointing to 9i database.

Replace the names withing quotes to the names relevant to your current exisiting database link.

If you want to find the details of the existing links, query the view dba_db_links.

I don't understand what you are saying:

Creating this link is part of your work schedule or not ? Am I missing something here ?

[Edited by sreddy on 07-08-2002 at 03:08 PM]

Some people are just to lazy to do the legwork. In other words:

Quote:

---

There are pauses amidst study, and even pauses of seeming idleness, in which a process goes on which may be likened to the digestion of food. In those seasons of repose, the powers are gathering their strength for new efforts; as land which lies fallow recovers itself for tillage.
J. W. Alexander

---

Quote:

---

Originally posted by Gayatri
If someone asks question or puts question in this forum guys u need to answer instead of sending ur expert comments on it.


Gayatri selvarajan

---

Answer something that is meaninful, why answer something which is perfectly documentated? Takes 2 minutes to look for the syntax

So giving a SQL syntax is an expert comment, LOL

Quote:

---

Originally posted by kavithared
I KNOW DEAR FRIENDS
BUT I AM VERY BUSY WITH WORK SCHEDULE.
THANKS

---

Ah, that changes everything! We didn't know that, sorry. I'm sure pando or some other fellow that has nothing else to do in this world will now rush to consult Oracle manuals and retype you exact and correct syntax for creating database links, so that you will be able to catch up with your work schedule.....

Quote:

---

Originally posted by jmodic
I'm sure pando or some other fellow.....

---

Ups, sorry, I ment to say "I'm sure Gayatri or some other fellow...."....

Hiii thanks,
Can you check my stored procedure?
don't feel .
thanks
kavitha

hiii,generally this type of forums for who are lagging in subject.Every one is not become a master .
thanks

Why learn it when somebody will just tell it to you? I think

Quote:

---

You live and learn. At any rate, you live.
Douglas Adams

---

is appropriate...

Can you check my stored procedure?
don't feel .

kavitared

by the way where is the stored procedure posted. ?

Quote:

---

Originally posted by kavithared
hiii,generally this type of forums for who are lagging in subject.Every one is not become a master .
thanks

---

this is a technical discussion forum, not a question answer forum

Forum means exchange of knowledge where one puts a question and others answer .

Meaning of Technical forum is also the same in this kind of scenario.

so a create database link syntax is something to exchange oh dear.... what has this become to

and what can people who only asks contribute? nothing

Quote:

---

I KNOW DEAR FRIENDS
BUT I AM VERY BUSY WITH WORK SCHEDULE.
THANKS
__________________
kavitha

---

... and have enough time to post the questions on dbasupport.
I don't think it will take more than 2 minutes to check syntax in manual or online docs.....

Sanjay


[Edited by SANJAY_G on 07-09-2002 at 01:47 AM]