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

    Unanswered: 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
  •