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...."....