Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    20

    Unanswered: Moving table data from one server to another in oracle

    Hi ,

    I have 2 servers with their userid/ pwd/databaseServer
    1: gcbadm/gcbadm/bsgcbdev
    2: gcbadm/devadm/gcbrd1

    Data has to be moved from bsgcbdev to gcbdr1 server.

    We have already created the tables that are in bsgcbdev. I would like to know how can we move the data in the tables to the new server .

    Any help is appreciated

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    imp/exp (impdp/expdp if it's available in your version)

    database links would be the easiest if there's not a lot of data to move.

    -Chuck

Posting Permissions

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