-
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
kavitha
-
read the manuals
it's free in case you dont know
-
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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
kavitha
-
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]
Reddy,Sam
-
Some people are just to lazy to do the legwork. In other words:
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
yodaDBA@hotmail.com
-
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
-
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.....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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...."....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|