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

Thread: Retrieve records from another database

  1. #1
    Join Date
    Nov 2003
    Location
    Israel
    Posts
    15

    Retrieve records from another database

    Hi,
    Please help me for retrieving data from a table in a database to the same table located in another database, not on the same server, different users and passwords.
    I need suggests about the SQL Statement, or if somebody can help me how to do this using Toad, it will be O.K.
    Thanks in advance,
    Richard

  2. #2
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    select * from RemoteUser.RemoteTableName@RemoteDatabaseLink

    ask your DBA to create a remote database link.

    (or)

    refer the syntax for creating remote database link.

  3. #3
    Join Date
    Nov 2003
    Location
    Israel
    Posts
    15
    thanks

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