Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Unanswered: Moving data from production to test (Oracle 10g)

    Hello,
    I'm fairly new to Oracle 10g... I have two instances, 'test' and 'production' on the same server... The test instance has all the structures that that production has, but its tables are empty. Therefore, I want to transfer all of the 'production' data over to 'test'..... I'm seeing conflicting opinions on which method is the most efficient /best to go about this (e.g. COPY command versus data pump utility) . Does anyone have any suggestions to go about this?

    Thanks
    T.

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Look into cloning
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

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