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

Thread: Connection string to remote server

  1. #1
    Join Date
    Aug 2000
    Posts
    29
    I am trying to copy a table from one database on server A
    to another database on server B

    My SQL:
    create table prop as select * from temp.prop;

    How do I tell Oracle to grab the table from server A.
    I can connect and view my database on server A. from
    server B
    EX:
    connect user/temp@serverA

    Thanks,
    scotta
    J.Scott Adams

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Create a database link of SERVER-A on SERVER-B then use that link to connect and extract information.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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