merging 2 oracle databases - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: merging 2 oracle databases

  1. #11
    Join Date
    Jul 2006
    Posts
    6
    Ken,

    >How much downtime can you actually tolerate?
    We can actually bring the databases down for say 30-35 hours on the weekend if required.

    Do you have any long, long/raw, clob or blob columns in your data?
    >NO...its just plain data.....but have huge tables (4-5 tables) containing almost 10 million records each....

    Is your data timestamped?
    >What do you mean by timestamped?

    ixion...thanks for your suggestions....will think over them and get back to you....

    Thanks,
    Reddy.

  2. #12
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    >timestamped...
    Does your data have date/time columns like created_on and/or last_mod_on?

    With this you could pick a point in time to copy rows to the new db, backfill using the timestamps, then switch your client/app to the new db with very little downtime. But you've got GOBS of time. Lucky...

    The nice thing about your scenario is that you can do a test migration on your new hardware.

    I'd consider pre-building your tables before you import. It's a good time to look at compression (requires a rebuild or a direct path load to actually compress .. I believe), Index Orgainzed Tables, uniform extents, etc.

    So many things to consider. 30 hours ...

    Ken
    Bow to your Sensei...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #13
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by reddybc
    ixion...thanks for your suggestions....will think over them and get back to you....
    PM Sent.

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