Results 1 to 4 of 4

Thread: Copy datafiles

  1. 07-24-2006, 03:58 PM #1
    kanif1
    kanif1 is offline Registered User
    Join Date
    Jul 2006
    Posts
    1

    Copy datafiles

    I have test database on one server but the data is too old. I need to refresh that data from production.
    What is best way.
    Reply With Quote Reply With Quote
  2. 07-24-2006, 08:53 PM #2
    stecal
    stecal is offline Registered User
    Join Date
    Oct 2005
    Posts
    2,557
    Export/import, RMAN, clone, cold backup, etc.
    Reply With Quote Reply With Quote
  3. 07-25-2006, 03:52 AM #3
    wommit
    wommit is offline Registered User
    Join Date
    Jul 2006
    Posts
    5
    But don't forget about the implications of any Data Protection legislation that you may be subject to. Using LIVE data in a test environment setup you up for a BIG fall.
    Reply With Quote Reply With Quote
  4. 07-26-2006, 03:48 PM #4
    clp
    clp is offline Registered User
    Join Date
    Jun 2006
    Posts
    4
    export/import is the easiest way to go if you have a small database. You can also just export/import tables of interest if you don't need the entire database. Also can be good if the structure has changed. You can drop the structure in the old and import it with the data from the newer source.

    clp
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules