DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: DBLINK

  1. #1
    Join Date
    May 2002
    Posts
    232
    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    read the manuals
    it's free in case you dont know

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  4. #4
    Join Date
    Dec 2001
    Posts
    50
    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

  5. #5
    Join Date
    May 2002
    Posts
    232
    I KNOW DEAR FRIENDS
    BUT I AM VERY BUSY WITH WORK SCHEDULE.
    THANKS
    kavitha

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  7. #7
    Join Date
    May 2002
    Posts
    219
    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

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  10. #10
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  


Click Here to Expand Forum to Full Width