Database Link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Database Link

  1. #1
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Hi I created a Database link from user test to fetch records from the another database with the same user test.

    Database link was successful. The problem is, when I am trying to use it , it is giving the error

    Select * from test@prod1;

    ORA-12514 : Message 12514 not found; product=RDBMS; facility=ORA

    Can any one suggest me where I am doing wrong

    [Edited by Kishore on 05-09-2001 at 02:55 PM]
    Thanks
    Kishore Kumar

  2. #2
    Join Date
    May 2001
    Location
    California
    Posts
    11
    You have to create the link so:

    create database link el_sur
    connect to usuario identified by clave
    using 'El450Sur';

    usuario is the user;
    clave is the password
    el_sur is the link's name.

    ---
    Then in $ORACLE_HOME/network/admin/tnsnames.ora
    add it

    El450 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= enel02)(Port= 1521))
    (CONNECT_DATA = (SID = conv))
    )

    enel02 is the name of the remote machine, conv is de database name.

    ---
    Now you can do it:

    select * from your_table@el_sur;

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Thanks, it is working. Infact my 2 databases are having the same GLOBAL NAME and is the problem I faced. When I chaged it back, every thing is fine.
    Thanks
    Kishore Kumar

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