dblink
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: dblink

  1. #1
    Join Date
    Aug 2000
    Posts
    21
    Hi
    Can I create a dblink without changing the global_names parameter to false. If so could any of you pls specify.
    BSR

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    By default the value of GLOBAL_NAMES is TRUE.You can create the database link even if the value of GLOBAL_NAMES is TRUE.
    But when u create the database link when the GLOBAL_NAMES=TRUE the database link name should be same to the database to which it points.

    e.g Say u have 2 databases database A and database B and you want to create database link from A -> B so u have to give the command

    create public database link B
    connect to scott identified by tiger using 'B';

    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You got the basics above. But with GLOBAL_NAMES set to TRUE you may face several problems with your DB links (Oracle Parallel Server for example). But on the other hand GLOBAL_NAMES set to FALSE might cause you problems if you want to use advanced replication.


  4. #4
    Join Date
    Aug 2000
    Posts
    21
    Thank you very guys
    BSR

  5. #5
    Join Date
    Dec 2001
    Location
    Phoenix, AZ
    Posts
    3

    Lightbulb Database Link Names - undocumented option if GLOABL_NAMES=TRUE

    Found this in a Metalink article (DocID=1024124.6)

    This is not documented in the Oracle manuals and can be useful (even required) when the init.ora parameter GLOBAL_NAMES is set to TRUE.....
    Note that if GLOBAL_NAMES is set to FALSE, you can name the dblink anything you desire.

    Database Links
    --------------
    Database links are created using the following syntax:

    SQL> create database link
    connect to identified by
    using '';

    The name of the database link should match the global name of the target
    database if GLOBAL_NAMES=TRUE. This may seem restricting since then there can
    be only one database link per schema to a given database if global_names is
    set to true. To overcome this use database link qualifiers. For example:

    SQL> create database link oradb@link1
    using 'D:BOSTON-MFG';

    NOTE: in this example, 'link1' is database link qualifier
    and 'D:BOSTON-MFG' is the connect string

    My NOTE : your select to the remote database would look like this :
    select * from table_name@oradb@link1;

    Hope this helps...
    -Tom

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