DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Data Archiveing

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455

    Data Archiveing

    Does anyone has any kind of Documentation on Data Archiving.

    Thanks in Advance

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Could you be more specific?

    (Some of ours we tie up with string, put it in cardboard boxes and keep it in the basement well it is on paper!)

  3. #3
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    I'm trying to identify the Data Archiving strategy and procedures to be used to Archive historical data from Data Warehouse, For that reason I need to understand what to look for and in genral some tips and tricks.

    Thanks

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Partition by date range, export the old partition, then drop it.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Export partition data as transportable tablespace, so you can plug it in quickly.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

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


Click Here to Expand Forum to Full Width