Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195

    Copy row from one database to another

    These two databases have the same tables and the same table structure. How can I copy 3 rows from database A to database B? Do I have to have a database link? Thanks, Jeremy
    Nothing better than a good ride.

  2. #2
    Join Date
    Jul 2002
    Posts
    29
    A database link would be the easiest way to do in
    for eg insert into tab_a select * from tab_a@dblink

    Or you could try export / import

    -- rajXesh
    All you need in this life is ignorance and confidence, and then success is sure.
    -- Mark Twain (1835 - 1910)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •